Running a delete query in Access 2010

  Neill 23 Nov 11
Locked
Answered

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

  Neill 24 Nov 11
Answer

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.

Advertisement

This thread is now locked and can not be replied to.

Should I upgrade to Windows 10? 8 reasons why you should upgrade to Windows 10... and 2 why you…

We are being sold the ability to spend money we don't have. And we love it

See 24 hours in London in 1 minute with Paul Richardson's hyperlapse film

How to use Apple Music in the UK: Complete guide to Apple Music's features

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