exporting issues in Access
Posted on 2016-10-23
So I am trying to export a report to an excel spreadsheet. After selecting the export button the XLS is created however two issue are surfacing.
1. The columns are not aligned in the XLS as they are in the report.
for instance first column in the report is now column 8 in the XLS. Everything is not in the same order as I see in the report.
2. I create a column in my query (Member #: Left([Claim#],9)) works fine in the report, but when it is exported it is saying "the number is formatted as text ..."