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,
Use a real SQL query tool, or don't select those fields. MS Query can't handle them, it doesn't know how to put brackets around the field names.
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.
That did it, thank you so much
*Community Hub is the new name for Sage City