SQL statament to search date

Hi,
i faced problem to retrieve a certain data from database(access 97). I only want to display a certain record from a date to another date. What SQL statement should i put?
hope u guys can help me, thanks.

You could try something like:

SELECT * FROM TableName WHERE DateField BETWEEN #Date1# AND #Date2#


Paul

select * from table where datefield is between #FromDate# and #ToDate#

for instance, from 1/1/2000 to 6/30/2000:

select * from table where datefield is between #1/1/2000# and #6/30/2000#

We're both wasting our time, monte96. This question was posted and already answered in the general forum. Gotta love it.

Paul

That is my pet peeve of the week. People who post their question multiple times in multple places, sometimes multiple times inthe same place. grr.