hi guys,

I have a field name DateEntered in an Access table.

I need to get all the current date - 1 records from that table.

cud anyone let me know the syntax for that query.

I tried in this way but cudn't get the records

SELECT[Traffic Accidents].[Date Entered]
FROM [Traffic Accidents]
WHERE [Traffic Accidents].[Date Entered] = Now -1;

Krish Reddy

Now returns the time as well as the date. I believe what you want is DatePart(Now) - 1.

the syntax on the datepart is +datepart("d",now())-1 where you want to return the specific day.

"m" for month
"y" for year etc.

"SELECT [Traffic Accidents].[Date Entered]
FROM [Traffic Accidents]
WHERE [Traffic Accidents].[Date Entered] = #" & DateAdd("d", -1, Date()) & "#"


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division