I would like to pull records from a database based on the date.

I am using SELECT firstname,lastname,email, stage_download
FROM customers WHERE stage_download = 21/01/02

But this does not pull the records. If I use <> 21/01/02 it pulls the records even those with a date of 21/01/02!

The date is a date/time field in Access 2000.

What do I need to do to filter dates?

Thanks

Put the date between #

WHERE stage_download = #21/01/02#

Mark.