Query Problem?

[JJPetersen1]

I have a date field (StartDate). In a query I created a field to extract the year from that field .. vYear: DatePart('yyyy',[StartDate])



This works fine. When I run the query, only the year shows, which is what I want.

What I want to do is have the user enter a year to pull that data. So I placed [Enter Year] in the Criteria.

When I run the query nothing appears.

What am I doing wrong?

[Welshgasman]

Try Year(StartDate)

Edit: However it works fine for me?

[June7]

It should work. Show your complete SQL statement. Alternative is Year() function.

SELECT * FROM table WHERE Year([StartDate]) = [Enter Year];

I never use popup input parameters because cannot validate user input. They could type anything including letters in which case results will be wrong and frustrate user. Refer to form control for user input and validate user input before running query or opening form or report or whatever. I never use dynamic parameters in query at all. I prefer to apply filter to form or report.

Users shouldn't interact with tables and queries, only forms and reports.