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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
I think it would be...

Between DateSerial(Year(date())-2,1,1) and DateSerial(Year(date())-2,12,31)
 
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)
 
You must log in or register to reply here.

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
Duplicates - Query Joining 1
Return a date range based on today's date 6
Query for YTD Total 6
Query to pull people with no activity prior to a certain date 1
Date serial for 2 months prior 2

Back
Top