The code below shows the correct order of information that is going into excel.
However when tranferred to actual workspace the last two columns are moved in 3 columns to the left.
This information is coming from an Access Table which is showing in the same order as the columns below.
Could it be in the Access Table. Everything looks fine.
Any suggestions. Thanks
SQL query
SELECT `System Balance table for Excel`.Year, `System Balance table for Excel`.`Fiscal Month`, `System Balance table for Excel`.Month, `System Balance table for Excel`.storenum, `System Balance table for Excel`.sbdate, `System Balance table for Excel`.netsales, `System Balance table for Excel`.overshort, `System Balance table for Excel`.avgticketcust, `System Balance table for Excel`.disccount, `System Balance table for Excel`.custcount, `System Balance table for Excel`.transvoidttl, `System Balance table for Excel`.refundcount, `System Balance table for Excel`.refundttl, `System Balance table for Excel`.Donors, `System Balance table for Excel`.`Z-Racks`, `System Balance table for Excel`.Carts, `System Balance table for Excel`.`Cash Donations`, `System Balance table for Excel`.totaldiscounts
FROM `C:\ArgisCentral\Database\Argis Retail Database`.`System Balance table for Excel` `System Balance table for Excel`
However when tranferred to actual workspace the last two columns are moved in 3 columns to the left.
This information is coming from an Access Table which is showing in the same order as the columns below.
Could it be in the Access Table. Everything looks fine.
Any suggestions. Thanks

SQL query
SELECT `System Balance table for Excel`.Year, `System Balance table for Excel`.`Fiscal Month`, `System Balance table for Excel`.Month, `System Balance table for Excel`.storenum, `System Balance table for Excel`.sbdate, `System Balance table for Excel`.netsales, `System Balance table for Excel`.overshort, `System Balance table for Excel`.avgticketcust, `System Balance table for Excel`.disccount, `System Balance table for Excel`.custcount, `System Balance table for Excel`.transvoidttl, `System Balance table for Excel`.refundcount, `System Balance table for Excel`.refundttl, `System Balance table for Excel`.Donors, `System Balance table for Excel`.`Z-Racks`, `System Balance table for Excel`.Carts, `System Balance table for Excel`.`Cash Donations`, `System Balance table for Excel`.totaldiscounts
FROM `C:\ArgisCentral\Database\Argis Retail Database`.`System Balance table for Excel` `System Balance table for Excel`