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

Windows 10 release date, price, features. The next version of Windows will run on everything:....

IDG UK Sites

An Apple fan's perspective on the Windows 10 launch

IDG UK Sites

Sensor-laden kids' watch with 3G launches in Japan

IDG UK Sites

2014 Retina iMac release date rumours, specs and features: 27in 5K Retina iMac 'launching this mont'......