Show current year data only.

F

Floyd Forbes

I have a query with this year data and last year data. Without deleting last
year data. How can I only show this year data by writing an expression?
I need an expression that will change on it's own 12/31/05 to 1/1/2006.

Floyd
 
A

Allen Browne

In the Criteria row of your query:

Between DateSerial(Year(Date()), 1, 1) And DateSerial(Year(Date()), 12, 31)
 
Top