Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

number displayed different in datasheet view in query

Posted on 2012-03-23
3
Medium Priority
?
346 Views
Last Modified: 2012-03-24
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
Comment
Question by:davetough
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 51

Accepted Solution

by:
Gustav Brock earned 2000 total points
ID: 37759373
Just apply the format you prefer to that field of the query.

/gustav
0
 

Author Closing Comment

by:davetough
ID: 37760400
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
 
LVL 51

Expert Comment

by:Gustav Brock
ID: 37760408
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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question