Syntax error

**nejenkins** · 10-28-2017, 02:23 AM

In a query, one of my field gives an error when I click to filter or sort. The field is a lookup field from a number in one table to a related look up table. Any ideas on what is wrong. It doesn’t always happen

**June7** · 10-28-2017, 02:47 AM

What filter/sort method - right click shortcut? What error message?

**nejenkins** · 10-28-2017, 03:03 AM

Right click
Syntax error (missing operator)

**June7** · 10-28-2017, 03:14 AM

I don't understand how right click shortcut can produce that error. I am not able to replicate.

**nejenkins** · 10-29-2017, 07:50 AM

does this help, this occurs when i press on the arrow at the right end of the field title

**orange** · 10-29-2017, 08:05 AM

Please post the sql of the query (sql view in query design).

You could post a copy of your database so readers can experience the error.

**John_G** · 10-29-2017, 08:16 AM

Your field Proposed Infection has a blank in it. Try changing it to Proposed_Infection to see if that works. This might be one of those times where a blank in a field name really does cause a problem.

**orange** · 10-29-2017, 08:22 AM

Is this a new issue or part of https://www.accessforums.net/showthread.php?t=68841

**June7** · 10-29-2017, 12:33 PM

And that is NOT right click shortcut, it is left click on a dropdown.

Syntax error

Thread Tools

Syntax error

Similar Threads

DLookup run-time error '3075': Syntax error (missing operator)

Run-time error '3075': Syntax error in string in query expression

Run-time Error - Compile Error: Syntax Error

Run-time Error '3075' - Syntax error (missing operator) in query expression

Incomplete Syntax Clause (syntax error)

Posting Permissions