Retrive data by entering 2 dates

[zami]

hi
i want to display data which is in access database and one date field, i want to show a data from date1 to from date 2
somene help me

[Kupo?]

Need to run a SQL query:

SELECT * 
FROM table 
WHERE date>=#1/1/2007# AND date<=#1/2/2007#

(all records between 1/1/07 and 1/2/07)

Then display however you need.