Need help with a complicated SQL statement

  • Thread starter Thread starter Mark Hackenberg
  • Start date Start date
M

Mark Hackenberg

Hi,

I have an Access 2000 database and one of the columns is a
time/date stamp when the date was entered. I want to be
able to run a query of all records within a week of the
current week i.e. if today is Dec. 23 I want to be able to
look up all records where time/date stamp column is Dec.
16-Dec 30.

Does anyone know the appropriate SQL statement for this?

Thanks,

Mark
 
Back
Top