Chris
Reputation: 21
MS Access 2007 - Receiving Syntax Error in query expression
MS Access 2007 - Receiving Syntax Error in query expression. Want to delete a record from one table (Parties) using another table's (Export_Extras) field (EmailEfile does not contain Email)
delete from Parties where Document_ID in
(select Document_ID from export_extras where EmailEfile is not like '%Email%')
Upvotes: 2
Views: 216
Answers (1)
Newd
Reputation: 2185
I am almost positive the wild card is * not % as you can see here: http://www.techonthenet.com/access/queries/like2007.php
Upvotes: 3
Related Questions
- Syntax error (missing operator) in query expression Microsoft Access
- MS Access in query: The expression you entered contains invalid-syntax
- MS-Access : Syntax error (missing operator) in query expression
- Getting syntax error (missing operator) in query expression in MS Access
- Getting Syntax error while executing following query in ms access
- Syntax error (missing operator) in query expression
- syntax error (missing operator) in query expression in MS Access
- SQL syntax error in query expression
- Syntax error (operator missing) in query-expression?
- SQL Syntax error with ms-access query