Stuart McLachlan
stuart at lexacorp.com.pg
Tue Jun 17 23:06:32 CDT 2003
On 18 Jun 2003 at 13:31, Darren DICK wrote:
> 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?
>
Try Year(Date())
--
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System
Support.