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.
 
Back
Top