How do I set up a query for information prior to the prior year?

K

kda1234

I need to have a query pull just the information prior to the previous year.
This query will be used to pull information for a report that will be run
every year.
 
R

Rick B

I think it would be...

Between DateSerial(Year(date())-2,1,1) and DateSerial(Year(date())-2,12,31)
 
V

Van T. Dinh

I take it that you mean anything on or before 31/Dec/2003 if you run the
Query today?

In that case, use:

.... WHERE [DateField] < DateSerial(Year(Date()) - 1, 1, 1)
 
Top