Choosing a special criteria
Wed, 7 Jan 2009 02:57:01 -0800
I want to use a special criteria in some field with something like " IF THEN
" function, for example, If [form]![employees details]![country]="USA" THEN
preview all the countries list.
I think that MS ACCESS does not have the IF THEN function, what is the
alternative and how to use? ...
|
Change Date Format in MS-Access
Tue, 6 Jan 2009 23:51:01 -0800
I want change my Date format as British format dd/mm/yyyy how can i change?
Please reply me. Because I search between dates data query.
Thanking You Advance ...
|
query does not use data from appended table
Tue, 6 Jan 2009 23:17:01 -0800
Hi,
I'm having a problem with my query. I've created a query that displayed all
'Volunteers information' which ran fine. However I then imported data from
Excel into a new table 'sheet1' and appended it to table 'Primary_info' that
I used in the query. The way I did this was by right-clicking 'sheet1' and
...
|
too large query
Wed, 07 Jan 2009 07:02:58 GMT
We have a form with many parameters for classes in a school. After choosing
parameters, there is a subform that gives a minimum amount of information
about all the classes requested according to the parameters.
On that same form is an option to get two different reports about the
selected classes. I am now t ...
|
Halt a Query
Tue, 6 Jan 2009 16:33:00 -0800
What is the best way to halt or force a query to stop that has been running
for an excessive amount of time because you included incorrect parameters?
And of course, it hasn't been saved yet, so forcing Access to close is not a
preferred option.
Ctrl+Break doesn't seem to be doing the trick this time... h ...
|
query based on combo box on form not working. Coming back blank
Tue, 6 Jan 2009 15:49:00 -0800
I am trying to run a report based off a query that uses a selection from a
combo box for the selection criteria. The criteria is below for the field
tblItem.ProjectStatus (the criteria is listed in the criteria cell in qry
design).
=[Forms]![frmReports]![StatusSrch]
When I run the query with the form open ...
|
Date function voodoo in my query
Tue, 06 Jan 2009 20:59:49 GMT
I'm pulling my hair out...In my query, I want to use the following criteria
to filter:
"Sort all records in the past 7 days from a specific date". I can not find
the right expression to do this. The one I'm stuck one works great from
TODAYS date:
>=DateADD("WW"),-1,Date())
This works great! But I want to b ...
|
|
|
One record from many based upon single field
Tue, 6 Jan 2009 12:07:02 -0800
I have a query that returns more than one record per unique field (AssocID).
I would like to return only 1 (first?) record per unique field. Is there an
easy way to do this? Thanks!
--
Kemo ...
|
Repeating records in Query
Tue, 6 Jan 2009 11:20:11 -0800
I am pretty new at building databases and I am having the following problem:
I currently have a query set up to pull records from a Union query, a select
query (qryWithdrawalDateOFFLabel) and a regular table. For some reason the
query will repeat the records when run. I checked the record sources (union
q ...
|
Combine two columns into one in a crosstab query
Tue, 6 Jan 2009 11:13:05 -0800 (PST)
Is it possible to combine two columns in one in a crosstab query? For
example:
TRANSFORM First(qryVDRProductionRuns.TestValue) AS FirstOfTestValue
SELECT dbo_vwPlant.Name, qryVDRProductionRuns.ProductCode,
qryVDRProductionRuns.PositionRow, qryVDRProductionRuns.ProductionDate
FROM dbo_vwPlant INNER JOIN qryVDR ...
|
