SQL statement for 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.

Use the WHERE clause. For example:

SELECT * FROM tablename WHERE fieldname>=date1 AND fieldname<=date2

Hi,
In order to retrieve records based on dates in ACCESS you have to give # both sides of the date.Here is an Example

select <field name> from <table name> where <date> between #01/01/1920# and #01/01/2000#

Try this query and see whether it is working for you.This will work as i have tested it.

Good Luck

I gave an answer similar to anilgoje's in the ASP forum...gotta love it when the same question is posted in multiple forums!

Paul