Date range help

  • Thread starter Thread starter Tara
  • Start date Start date
T

Tara

I need to create a query in which only data from the prior year will be
appended to a new table. So, this year I will need to append data from 2007
only, next year 2008 data only, etc. Is there an easy way to do this?

Thanks,

Tara
 
Can we assume there is a date field in your table that can be used to
determine "data from the prior year"? There are some very versatile date
functions that you can use to filter your range of records. Open any module
and search Help on DateAdd(), DateSerial(), Year(), etc.
 
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

Choose append field based on criteria 4
Append query to append lots of record with range input 7
Max & Min Dates 0
Access 2010 append query to SQL is very slow 0
conditional appending through append query 1
conditional appending 1
Comparing Amounts in prior years 2
how convert Date-Time to Date only 2

Back
Top