Table, Field, Datatype

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

Guest

I have a table in Access 2003. One field should display 9-12 digits. I have
this field set as a number for calculation in my queries. It works fine for
the smaller numbers, but when it gets to the larger numbers it quirks. My
number becomes a scientific notation. My field is set as Data Type - Number,
Field Size - Double Decimal Places - 0. Why won't my longer numbers stay
numbers?
 
Are you just trying to view the numbers in the table or are they outputting
to a file in that format? You most likely just need to expand the field for
vieing in the table.
 
I have expanded the field to the whole width of the page and it did not
change. Cycling through all my queries, when this comes to print out on the
report it is still in scientific notation format.
 
The Decimal Places property is ignored unless you make an entry in the
Format setting. Try selecting Format = Standard and Decimal Places = 0.
If you don't want commas, try Format = #0.

Jerry
 
BINGO!! We have a winner!! Thank you so much!

It didn't like "Standard" as much as it did "fixed" but I never would have
looked there without you mentioning it! Thank you!
 
Back
Top