Passing a date range into a crosstab query

[devyon122]

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

[JConsulting]

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