Search code examples
sqlms-accesssql-deletemismatch

DELETE in Access?

I'm trying to use the delete command in Access using the shown specifications, but Access keeps saying "Data type mismatch in criteria expression." Does anyone know what to do?

DELETE ORDERS.OrderDate, ORDERS.CustomerID
FROM ORDERS
WHERE (((ORDERS.OrderDate)='2008-01-24') AND ((ORDERS.CustomerID)="C0003"));
Solution 
  • DELETE ORDERS.OrderDate, ORDERS.CustomerID, * FROM ORDERS WHERE
(((ORDERS.OrderDate)=#1/24/2008#) AND ((ORDERS.CustomerID)=3));