J
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
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