Microsoft Access Missing Operator Syntax Error.

codymartin5954 · 2011-09-30T14:38:24.000Z

So, I make a query and that’s all fine, but when I click the arrow to sort on the field names I get a syntax error. But when I use the simple query wizard. I don’t.

I have to use the query design button, and i have no idea why this is happening. Using two tables to make a query.

pchiodo · 2011-10-04T08:37:39.000Z

Can you post the Query statement? Or, in the alternative, post the Access query? I’ll be happy to take a look.