MS Query issues

SOLVED

I am trying to run some simple queries and use it for audit.  In this case I am running an AP register, but for some reason I am getting a syntax error in MS Query that it doesn't like the columns Check or Limit......any work arounds?

Thanks,

Parents
  • +1
    verified answer

    If you want to do it in MS-Query, exclude those fields to start.  Then you can edit the SQL statement - either in the Properties > Definition window or by clicking the SQL button at the top of the MS-Query window, and manually add those fields with square brackets around the problem words.

Reply
  • +1
    verified answer

    If you want to do it in MS-Query, exclude those fields to start.  Then you can edit the SQL statement - either in the Properties > Definition window or by clicking the SQL button at the top of the MS-Query window, and manually add those fields with square brackets around the problem words.

Children