Date Query: Annual Data Based off of Form Date

[steveabni]

Hello Everyone,
I've built a crosstab query and what I'd like it to do is only pull in data for the year that is selected from a form. I thought I had the where clause written correctly, but the query ends up displaying all records instead of the year based on the date in the form.

PARAMETERS [forms]![Main Menu]![End Date] DateTime;
TRANSFORM Avg([Stock Adjustments].Cost) AS AvgOfCost
SELECT [Stock Adjustments].Whse, Avg([Stock Adjustments].Cost) AS [Total Of Cost]
FROM [Stock Adjustments]
WHERE ((Year([forms]![Main Menu]![End Date])=Year(Date())))
GROUP BY [Stock Adjustments].Whse


PIVOT [Stock Adjustments].[Manual Log];

If someone can point me in the right direction I'd appreciate it.

[June7]

The WHERE must reference a field to apply filter to.

WHERE Year([End Date])=Year(Date())

[steveabni]

June7,
Thanks for the reply. When I changed that line of the query I received a message that stated [End Date] wasn't recognized by the db engine. I entered [End Date] into the parameters area and then recieve a prompt to enter the End Date.

Is there a way to write this so it returns records of the year that's entered on the form?

[June7]

What is name of the field with the date value?

WHERE Year([fieldname])=Year([forms]![Main Menu]![End Date])

[steveabni]

That was it......Thank you again for your help June7, I appreciate it.