Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 46
  • Last Modified:

exporting issues in Access

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 ..."


Please help
0
seamus9909
Asked:
seamus9909
1 Solution
 
Gustav BrockCIOCommented:
1. That's by design. You cannot expect a 100% identical output.

2. Left returns a string, so that's why. Use:
   
    Member #: Val(Left([Claim#],9))

/gustav  
0
 
Rey Obrero (Capricorn1)Commented:
"1.  The columns are not aligned in the XLS as they are in the report."

do not export the report...

-create a query, formatted the way you want to see it in excel.
- export the query.
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now