Recent content by RosscoPeco

  1. R

    Syntax error (missing operator) in query expression <field name>

    Hi speaker_86 Thanks for your response. I tried everything you mentioned but to no avail eg I tried exporting the table from the query to a new access database but it seemed to filter ok. The database is in development. I have just disabled filtering on the form till I figure it out. The...
  2. R

    Syntax error (missing operator) in query expression <field name>

    Hi there I am using Access 2010 and displaying the contents of a query in a form. When I click on one of the column headers (ie where you sort and filter) I get the above error. I can click Ok and then am able to sort the column but it doesn't show any of the values to filter on. Not sure where...
  3. R

    Hello to all

    Hello I have tinkered with Access over the years, only creating simple forms with a little bit of VBA. I hope to add a little bit of razzle dazzle to my forms in the near future so here I am. I live in Brisbane, Australia.
Back
Top Bottom