Delete Query (2000)

[bzimmer]

I am trying to delete records from a table that are older than one year from the current date. Here is my query:
DELETE tblDataLogger.ID, tblDataLogger.Unit1, tblDataLogger.Unit2, tblDataLogger.Month, tblDataLogger.Day, tblDataLogger.Year, tblDataLogger.Hour, tblDataLogger.Minute, [month] & "/" & [day] & "/" & [year] AS Datestamp
FROM tblDataLogger
WHERE ((([month] & "/" & [day] & "/" & [year])<=Date()-365));

However this does not find the records older than one year. Can someone please help.
Thanks,

[HansV]

Instead of

DateStamp: [month] & "/" & [day] & "/" & [year]

which results in a text value, try

DateStamp: DateSerial([year], [month], [day])

which results in a real date/time value.

[bzimmer]

Thanks, that works.