Calendar and Crosstab error 1

[JamesDSM50328]

I am having a problem and getting runtime error 3770. (Microsoft Jet does not recognize Forms!Apps!Calendar1 as a valid field name or expression)
I have 2 calendar controls on a form and need to use the dates from the calendar controls to pull the query.
I have several select queries that work just fine referencing the calendar values but the crosstab is not wanting to work.
Any assistance would be great

TRANSFORM Count(Applog.LoanNumber) AS CountOfLoanNumber
SELECT Applog.DateEntered
FROM Applog
WHERE ((Applog.DateEntered) Between (forms!Apps!calendar1) And (forms!Apps!calendar2))
GROUP BY Applog.DateEntered
PIVOT Applog.AppTaker;

 

[PHV]

You may try this:
PARAMETERS [Forms]![Apps]![calendar1] DateTime, [Forms]![Apps]![calendar2] DateTime;
TRANSFORM Count(Applog.LoanNumber) AS CountOfLoanNumber
SELECT Applog.DateEntered
FROM Applog
WHERE ((Applog.DateEntered) Between ([Forms]![Apps]![calendar1]) And ([Forms]![Apps]![calendar2]))
GROUP BY Applog.DateEntered
PIVOT Applog.AppTaker;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[JamesDSM50328]

Thanks that works perfect!

I really appreciate it!!