Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Syntax Error (missing opertator) in query expression.....

Syntax Error (missing opertator) in query expression.....

Syntax Error (missing opertator) in query expression.....


Is this a new bug in Access?

If I create a new table with a single field called: Asking Rent PCM and then create a query with this field, the query will open OK, but if I try to sort on that field I get the Syntax Error

If in the query I put something like AskingRent: [Asking Rent PCM] then it will sort fine.

I understand that you should not leave spaces in field names, but I'm working with an old database so can not change the names. Why does this happen - I dont recall that this used to be a problem?

Thanks Mark

RE: Syntax Error (missing opertator) in query expression.....

We would need to see the actual query to see what it might not like. I have heard of this issue before.

RE: Syntax Error (missing opertator) in query expression.....

As long as the field names are bracketed. Access should handle it okay (At least it has always worked for me).

RE: Syntax Error (missing opertator) in query expression.....

Yes I accept it is the space in the field name - just surprised i'd never noticed this before (of course my Field Names dont have spaces in them)


RE: Syntax Error (missing opertator) in query expression.....

Actually scrap that - it does seem to be some kind of bug.

If you create a new table and have a Currency field called say:
Asking Rent

If you then crete a query from this table (using the normal query design window), run it and then sort on that field, then the syntax error occurs.

If you then edit the table and change it to a short text field, then it works fine. You can then edit the table again and change it back to a currency field and it still works fine.

Very odd.

Regards Mark

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close