Critera in Crosstab Query

[Joy]

I'm trying to use a form text boxes to set the date critera for my crosstab
query. When I run it I receive a message stating "database engine does not
recognize '[Form]![OpeningPage]![StartDate] as a valid fieldname or
expression".

TRANSFORM Count(ReceiptDetails.[Receipt No]) AS [CountOfReceipt No]
SELECT ReceiptDetails.CDate, Count(ReceiptDetails.[Receipt No]) AS [Total Of
Receipt No]
FROM ReceiptDetails
WHERE ((([ReceiptDetails].CDate) Between [Forms]![OpeningPage]![StartDate]
And [Forms]![OpeningPage]![StartDate]))
GROUP BY ReceiptDetails.CDate
PIVOT ReceiptDetails.Office;

Any help would be great appreciated, this driving me insane

 

[Allen Browne]

Declare the parameters.

In query design view, choose Parameters on the Query menu.
Access opens a dialog.
Enter 2 rows:
[Forms]![OpeningPage]![StartDate] Date/Time
[Forms]![OpeningPage]![EndDate] Date/Time

I have assumed you actually have 2 text boxes you refer to: otherwise the
Between operator doesn't make sense.

More info:
http://allenbrowne.com/ser-67.html#Param

 

[Joy]

Excellent, works well. Thanks Heaps for that. Have a great day.
--
Thank Heaps

Declare the parameters.

In query design view, choose Parameters on the Query menu.
Access opens a dialog.
Enter 2 rows:
[Forms]![OpeningPage]![StartDate] Date/Time
[Forms]![OpeningPage]![EndDate] Date/Time

I have assumed you actually have 2 text boxes you refer to: otherwise the
Between operator doesn't make sense.

More info:
http://allenbrowne.com/ser-67.html#Param

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I'm trying to use a form text boxes to set the date critera for my
crosstab
query. When I run it I receive a message stating "database engine does not
recognize '[Form]![OpeningPage]![StartDate] as a valid fieldname or
expression".

TRANSFORM Count(ReceiptDetails.[Receipt No]) AS [CountOfReceipt No]
SELECT ReceiptDetails.CDate, Count(ReceiptDetails.[Receipt No]) AS [Total
Of
Receipt No]
FROM ReceiptDetails
WHERE ((([ReceiptDetails].CDate) Between [Forms]![OpeningPage]![StartDate]
And [Forms]![OpeningPage]![StartDate]))
GROUP BY ReceiptDetails.CDate
PIVOT ReceiptDetails.Office;

Any help would be great appreciated, this driving me insane