"Send to file" reports produce a percentage figure instead of text

  • Thread starter Thread starter Grub via AccessMonster.com
  • Start date Start date
G

Grub via AccessMonster.com

Hello,

I have a very nice database in Access 2003 that lists equipment around our
complex but this is my one problem with it.

My reports have a field on it "Location" and it is a value like e.g. "006P",
"016P", meaning "location 6 Printer port".

When I use the "send to file" button and export the report to "excel 97-2003"
the lower values come up as a percentage, e.g. 016P comes up as 0.6666666667.
006P comes up as 0.75 in the excel field for the location, while the others
seem to be fine.

Could anyone help me distinguish why this would be?

Appreciated.

Grub (sorry, it's my nickname)
 
Have you tried explicitly setting the format of the control to Text? It may
be that Access (and Excel) are "interpreting".

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Another approach might be to explicitly set the value in the report's
underlying query, and export the query to Excel...


Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top