"11510" Displays "E+04"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

My new camera 7
Installing XP 2
Access Access Report Works on One Machine but not Another 3
ID number showing 1
Why does my report display a value different than that of the que. 10
Missing data in Access reports 6
Report exporting different data from what is on the report 1
Report based on query shows no data 1

Back
Top