SQL statament to search date

[leeckeat]

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

[monte96]

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

[monte96]

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.