Creating a report that contains only the last 24 hrs

[lenebene]

I a trying to create a report from a table that only contains the last 24 hrs. The format of the date is "09/24/2002 9:01:50 AM". The table contains information from the past 5 months.

Any ideas?

 

[cmmrfrds]

The default for date arthimetic is day so you can just add 1 to the date and check, otherwise use the datepart function. DatePart("m", MyDate) 'checks for month

select * from table where mydate <= now()+1