Olusesan,
What data type did you use for your variable? I'm guessing either integer or long integer. You need to use either single or double which are floating point decimal values.
Darrell
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Olusesan Makinde
Sent: Monday, October 01, 2012 11:44 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] How to stop rounding down a calculated field in a report
Hi Guys,
I developed this database with calculated variables. I then used the calculated variables in a report. In the report, I grouped the variables and asked that it returns a sum of the claculated variables for each change in group.
To my surprise, the sum gives a rounded down number for the data points. For example 2.6 + 3.6 = 5.
Where can I turn this off please? I have looked all day and tried all sorts.
Thanks for your responses.
Olusesan
[Non-text portions of this message have been removed]
The information contained in this communication is highly confidential and is intended solely for the use of the individual(s) to whom this communication is directed. If you are not the intended recipient, you are hereby notified that any viewing, copying, disclosure or distribution of this information is prohibited. Please notify the sender, by electronic mail or telephone, of any unintended receipt and delete the original message without making any copies.
Blue Cross Blue Shield of Michigan and Blue Care Network of Michigan are nonprofit corporations and independent licensees of the Blue Cross and Blue Shield Association.
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar