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

G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

need to show current year and prior year totals 6
Comparing Amounts in prior years 2
Where Statement using DateAdd 3
Return a date range based on today's date 6
Duplicates - Query Joining 1
Query for previous week, Sun thru Sat, from date field 1
Query to pull people with no activity prior to a certain date 1
Query for YTD Total 6

Top