I'm trying to allow a user to type in a beginning data and an ending date to be used in a crosstab query - Below is the query:
- TRANSFORM Count(imagingdb.ID) AS CountOfID
-
TRANSFORM Count(imagingdb.ID) AS CountOfID
-
SELECT imagingdb.Scheduled, imagingdb.ATT, imagingdb.ACQ
-
FROM imagingdb
-
WHERE (((imagingdb.Scheduled) Is Not Null) AND ((imagingdb.ATT) Is Not Null) AND ((imagingdb.ACQ) Is Not Null) AND ((imagingdb.Project) Is Not Null))
-
GROUP BY imagingdb.Scheduled, imagingdb.ATT, imagingdb.ACQ
-
PIVOT imagingdb.Project;
It works if I type the date range Between 4/1/2007 And 4/30/2007 but I want to give the user a form and let them type in the range. I tryed the Between [Enter Beginning Date] And [Enter Ending Date] and I tryed a form for the date but to no avail.
Any help would be appreciated
n your crosstab query (query design grid) enter yr parameters in criteria for example: Between [Enter Beginning Date] And [Enter Ending Date]
Then select Parameters option from Query Menu and enter same for example: [Enter Beginning Date] And [Enter Ending Date] in data field u can type date and it will work.
If u are using a form to supply parameters then that would be same for example : [Forms]![Form1]![startdate] ^ [Forms]![Form1]![enddate]
J