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,
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
That did it, thank you so much
*Community Hub is the new name for Sage City