How do I reference TimeStamp data in a Delete query ?
I would like to delete all entries in a table that were
created before 2006. The data is stored in TimeStamp
format and is drawn from a linked MySQL table.
In Access, it appears as: 4/5/2006 1:47:25 PM
I would like to write a Delete SQL, such as:
DELETE * FROM Table WHERE TimeTS<2006;