Solved

multiplication calculation in report

Posted on 2012-03-26
5
313 Views
Last Modified: 2012-03-26
I am attaching database- open database - and click button 'preview report'

Is there anyway I can force the 6 wk turn column to multiply the [avg wkly usage] field by 6 like a calculator would- I am getting a little different number than a calculator gets.
I had this problem in query-
example:
6.80 * 6 = 40.8 ( calculator) in report (40.79)
I don't remember having this discrepancy before- ( and It would be a large thing to have to change data types in the real database- which i tried in example and did not seem to matter)
thank you,
TestMultiply.accdb
0
Comment
Question by:davetough
5 Comments
 
LVL 31

Accepted Solution

by:
Helen_Feddema earned 400 total points
Comment Utility
I suspect that the actual value in the table field (or the calculated weekly average) has a number of decimal points, and that may be affecting the calculation.  You could round the weekly average figure to avoid this problem, or round the final result.
0
 
LVL 33

Assisted Solution

by:Norie
Norie earned 50 total points
Comment Utility
The value in Avg Weely Usage is actually 6.79886655.

6.79886655 * 6 = 40.7931993 (calculator)

So 40.79 is correct I suppose.

If you change the format of that field in the table/report so it displays more decimal places you'll see the value.
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 50 total points
Comment Utility
<No Points wanted>

I'm with imnorie, ...

Access sometimes has issue with rounding...

To be sure, only perform rounding in your "Final" calculation.

The catch here is that if your "Source" values are rounded (or formatted) in the report, the "final" value may appear "off" slightly.

In the real world, mot people understand this if the difference is not "material"...
In your case the diff is (.01) one penny, ...generally not regarded as "Material"

So either you have Long "accuare" source data, and long accurate results,
...or you employ rounding/formatting and your data looks shorter, but you may have visble "Rounding" issues....

JeffCoachman
0
 

Author Closing Comment

by:davetough
Comment Utility
thank you- did not realize number has alot of decimal points
0
 
LVL 30

Expert Comment

by:hnasr
Comment Utility
Change format from double to currency.
Modify the values in the table. The report prints as expected.

This has to do with accuracy of saving numbers in memory.
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
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…

771 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now