12-06-2012, 01:42 AM #4 pr2-eugin Super Moderator Join Date: Nov 2011 Location: Bournemouth, UK Posts: Syntax Error Missing Operator In Query Expression Cast Syntax Error (Missing Operator) in Query Expression Access 2010 barry6614 asked Mar 16, 2012 | Replies (7) I have a simple query that when I try to filter on any of

with best wishes, Dave Very glad to have been able to help, Dave. or click the 'Thumbs up'. All product names are trademarks of their respective companies. http://axisnice.com/syntax-error/80040e14-syntax-error-missing-operator.php Industry-Specific IT We're a small managed services consultancy that is under a slightly larger non-tech company.

I am using ACCESS 2010. Password Register FAQ Community Top Posters Today's Posts Search Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find I have found that I can filter by right-clicking on a filled cell though. –FGLC0983 Feb 10 '14 at 14:50 add a comment| 5 Answers 5 active oldest votes up vote I have seen several postings about this error, but I am not seeing something that I can use to solve this problem.

I however discovered the following. Thank you for the tip. –RazorSky Sep 8 at 15:11 add a comment| up vote 3 down vote I had this same problem. My best guess is the query is not the cause of the problem. How would I share it then.

i dont want the numbers in that field to be repeated. Aug 15 '08 #7 reply Message Cancel Changes Post your reply Join Now >> Sign in to post your reply or Sign up for a free account. The sync is between the form (Combo box ) and a report (txt field). Does the suggestion work for you or not?

It must be something due to the method you're using to set the filter or a problem with the filter expression string. –HansUp Feb 7 '14 at 20:21 You Cheers. --------------------------------------------------------------------------------------------------------------------- pr2-eugin View Public Profile Visit pr2-eugin's homepage! I also noticed no data is listed for the records in the drop-down once it opens. This is one thing i will pop in my good gen folder.

Attached Images formProp.png (35.8 KB, 10391 views) __________________ Regards, Paul Eugin To view links or images in signatures your post count must be 10 or greater. This problem crops up fairly frequently in referring to string values, and arises because you are missing two quote marks from the filter statement. Aug 15 '08 #5 reply Expert Mod 2.5K+ P: 2,543 Stewart Ross Hi jghouse. Please post the exact syntax and sample. –Wayne G.

Thanks Andre Thursday, February 03, 2011 5:07 AM Reply | Quote 0 Sign in to vote This issue is almost exactly a year old but I'm still experiencing it on share|improve this answer answered May 13 at 10:07 Kasra 44 add a comment| up vote 0 down vote Put [] around any field names that had spaces (as Dreden says) and This is one thing i will pop in my good gen folder.