[AccessD] A2K: Date in Query

Darren DICK d.dick at uws.edu.au
Tue Jun 17 22:31:07 CDT 2003


Hello all
When I put msgbox Year(Date) behind a button click I get 2003. No Prob
When I put that criteria Year(Date) into a query Access changes it to Year("Date")
and of course it fails.
What is the correct syntax to search on the 'current year' on a field that holds that data?

Many thanks

Darren




More information about the AccessD mailing list