Re: [MS_AccessPros] How to stop rounding down a calculated field in a report

 

Try CCur() or CDbl() in rows.
-jma-

----- Original Message -----
From: "Olusesan Makinde" <sesmak@yahoo.co.uk>
To: <MS_Access_Professionals@yahoogroups.com>
Sent: Monday, October 01, 2012 5:44 PM
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]

------------------------------------

Yahoo! Groups Links

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (4)

Recent Activity:

• New Members 3
• New Files 1

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___