Date Query-show records 1 day old.

[Guest]

I have a db that needs to show all records that are over a day old. Yet my
query isn't working. It shows records that are over 2 days old. Can someone
tell me what I'm doing wrong??? Here is my query:

SELECT tblRecords.ReceivedPM
FROM tblRecords
WHERE (((tblRecords.ReceivedPM)<DateAdd("d",-1,Date())));

 

[Guest]

If the "over one day old" includes the current day, which mean you want to
see all dates beside the current date, then

SELECT tblRecords.ReceivedPM
FROM tblRecords
WHERE tblRecords.ReceivedPM<Date()

Or
SELECT tblRecords.ReceivedPM
FROM tblRecords
WHERE (((tblRecords.ReceivedPM)<=DateAdd("d",-1,Date())))