• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 350
  • Last Modified:

number displayed different in datasheet view in query

Hello ,
have attached database if you open it and open Query1 in datasheet view-
and click in avg wkly usage field- the number changes format to scientific I think?
something like 5.73123076923077E-02-
why does it do this?
I have another database and i notice alot of numbers are displaying in that format- and I wonder if it causes the 6 wk total field calculation to not mulitply correctly in this database?

thank you
DataMultiply.accdb
0
davetough
Asked:
davetough
  • 2
1 Solution
 
Gustav BrockCIOCommented:
Just apply the format you prefer to that field of the query.

/gustav
0
 
davetoughAuthor Commented:
thanks-
i do though still wonder why it is doing this?
is it when it imports? or is it microsoft offering options?
i have a database where I change format in the report and table - standard w/2 decimal places-
and the sum of the multiplication calculation- is always about .01 different than a calculator- would answer
0
 
Gustav BrockCIOCommented:
That is a common problem working with data type Double and indeed Single.
If possible, change the data type to Currency which handles up to four decimals "correctly" (= without rounding errors caused by floating point bit errors).

/gustav
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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