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
davetoughAsked:
Who is Participating?
 
Gustav BrockConnect With a Mentor CIOCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.