DATE() APPEND QUERY

[mercwonder007]

I have an append and delete query that aren't working quit right. I am trying to append all records older than today to a backup table. I have in the query a date field that has a condition as follows: Date()-1 and when I run the query it doesn't work. Any help would be great. Thank you.

 

[lupins46]

'doesn't work' is not much help...
If you want 'to append all records older than today '
you need <Date() as the criteria.

 

[mercwonder007]

Thank you... I'll give it a try