Access, SQL and dates

[ncar35b]

Hi, does anyone know of a good reference/site that deals with pulling records from an Access database by dates? For example, I need to pull all records between certain dates and also need to pull the record with the closest date to today from a table. I don't know the syntax for doing this.

Thanks!

- Josh

 

[Transcend]

Select * from table1 where dateField between #1/1/2000# and #1/12/2002

This is an example of the syntax you need, what is it you're having trouble with?

Transcend