Running a delete query in Access 2010

  Neill 16:42 PM 23 Nov 11

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 10:00 AM 24 Nov 11

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.


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

Surface Pro 4 UK release date, price and specs: Thinner, lighter, faster with new Type Cover and Pen

1995-2015: How technology has changed the world in 20 years

Territory delivers realistic NASA screens for The Martian - as they will be in 20 years time

21 brilliant tips for Mac OS X El Capitan: The best new Mac features in OS X 10.11