Date query

[Courtman]

Final problem for now I think!

I am trying to run a query to find all the records for the year-to-date, i.e. from 01/01/2001. I cannot get the query to enter the current year, I want it to look at

WHERE Date = CurrentYear

for its results.

Thanks to all in advance?

 

[anke]

you should be able to use something like
WHERE (((f_date_probs.xDate) Between "01/01/" & Format(Date(),"yy") And "31/12/" & Format(Date(),"yy")));

hth

anke