not vaild field name

[Jade]

Hi there,

I have three crosstab queries that I put together in a select query. I have a date field and I want to be able to pick between dates. I get the following error:

The Microsoft Jet database engine does not recognize [Form] as a valid field name or expression.

I am using Between [start Date] and [End Date] and this is the error I am getting

Here is my SQL
SELECT Test.Employee, Test.[Date Worked], Test.Day, Test.Night, test1.S_S, test1.[Act S_S], test1.[Op IV], test1.[Act Op IV], test1.[CR Op], test1.[WTP Op], test1.[Unit 1 Op], test1.[Unit 2 Op], test1.[ACR Sys], test1.Proj, test2.AWOP, test2.AWP, test2.BR, test2.BWD, test2.DA, test2.LD, test2.LT, test2.LTD, test2.OT, test2.SK, test2.STD, test2.TIL, test2.V, test2.X
FROM (Test INNER JOIN test1 ON (Test.[Date Worked] = test1.[Date Worked]) AND (Test.Employee = test1.Employee)) INNER JOIN test2 ON (test1.[Date Worked] = test2.[Date Worked]) AND (test1.Employee = test2.Employee)
WHERE (((Test.[Date Worked]) Between [Forms]![PER-TimeByPosition-Exception]![BeginningDate] And [Forms]![PER-TimeByPosition-Exception]![EndingDate]));

Please help.

Thank you,

Jennifer

[This message has been edited by Jade (edited 02-05-2002).]

 

[David R]

Are you trying to refer to a field on an open form? Try [Forms]!... or Me.xxxx instead?

Otherwise, post your SQL here and maybe someone can spot what went amiss.

HTH,
David R

[This message has been edited by David R (edited 02-05-2002).]

 

[Jade]

Thank you, Forcing the query parameters worked

Jen