update query with multiple criteria help

[mbellas21]

Hi everyone, working on a database and trying to figure out how to change an items name but only after a certain date in the table. Have tried putting in >#date# and other such variations but no such luck. Would appreciate any help on the subject.

[JoeM]

> #date#

should work, provided your field is really formatted as a Date, and not as a String. Can you confirm that?

Can you post the SQL Code you have tried, so we can at least see the structure and the names of the table and field?
You can convert any query to SQL code by switching to SQL View. Then just Copy and Paste the code here.

[euanl]

By > #date# I assume you mean >#01/02/2013# for example, not just the word date, if so then this should work. You could have >Date() which would return values greater than today's date, or >Date()-7 for greater than 7 days ago etc as well.