"11510" Displays "E+04"

L

LuhElle

I have a table in which the information in one field is always 11510, I have
a query based on that table, which, when run displays 11510, but when I run a
report based on that query, E+04 displays. When I export the report to
excel, it shows 11510 again, what is my problem?
 
D

Duane Hookom

Is the text box in the report wide enough to display all the characters? You
may also need to change the format to general or similar.
 
L

LuhElle

Thanks for the idea, but I'm sure that the field is large enough. Actually I
solved my own problem (after quite a while) . It took a lot, you see, I'm
working with a linked DB, and I can't change the data type in the main
table... which was limiting my data types for the query and report. SO, I
used an input mask to simply show "99999". Thanks for the help.
 
Top