We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
Contact Forum Editor

Send an email to our Forum Editor:


PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom


It's free to register, to post a question or to start / join a discussion


 

Running a delete query in Access 2010


Neill
Resolved

Likes # 0

I want to delete all orders placed in 2011. The Date field has criteria of Year([Date])=2011 (or I have tried Between 01/01/11 And 31/12/11). I can View the query which works and only displays orders in 2011. However when I run the query I get Unknown Function Date in Valedation Expression or default value on Orderdetails.Date

Strange that it Views OK but won't Run.

Any idea what I am doing wrong? Thanks

Like this post
Neill

Likes # 0

Having another play, the table had a field "Date" which must have been OK in Access 2003 because the Delete query worked, but is now a "reserved word" in 2010. Changed the field to DateOfOrder and all is OK.

Like this post  

Reply to this topic

This thread has been locked.



IDG UK Sites

Acer Aspire R11 review: Hands-on with the 360 laptop and tablet convertible

IDG UK Sites

Apple Watch release day: Twitter reacts

IDG UK Sites

See how Framestore created a shape-shifting, oil and metal based creature for Shell

IDG UK Sites

Apple Watch buying guide, price list & where to buy today: Which Apple Watch model, size, material,?......