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).]

 

[Pat Hartman]

Access is picky about parameters in crosstab queries (or their underlying queries). You need to specifically define the parameters. Right click on the gray background in QBE view, select parameters, enter the two parameters EXACTLY as you have used them in the query.

 

[Jade]

Thank you, Forcing the query parameters worked

Jen