I have the ODBC Drivers set up, and am using MS Query to pull data from Sage 300 CRE.
I want to create a searchable by date check register from Query.
The difficulty is the word "Check".
I am using the file APM_MASTER__INVOICE_PAYMENT file, and would like to return the column .Check.
However, Check is a command in SQL, and produces a Syntax Error.
I have tried .[Check], [APM_MASTER__INVOICE_PAYMENT],[Check], Check_Number, (which is not a column), and Check_Number.
No solution so far.
Has anyone solved this riddle?
thank you,
Joe Harper
------------------------------
Joseph Harper CPA, CCIFP
Cfo
Greater Dayton Construction Group
Beavercreek OH
(740) 607-1449
------------------------------