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