Discussion: View Thread

Sage 300 CRE, using MS Query

  • 1.  Sage 300 CRE, using MS Query

    Posted 11-26-2018 14:15
    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
    Greater Dayton Construction Group
    Beavercreek OH
    (740) 607-1449