By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,551 Members | 2,741 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,551 IT Pros & Developers. It's quick & easy.

Report shows wrong Sum() format

P: n/a
Hi all,

I am having three queries which I combined using an union query and each
query has a cost field. In the report when I try to get the sum([cost]) I
get a number with many decimal zero's all my cost field in the query are
single and have decimal property set to three. Any ideas why I am getting
such a long number after using the Sum() function? Pleaase advice.

--
'With Thanks'
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Newbie wrote:
Hi all,

I am having three queries which I combined using an union query and each
query has a cost field. In the report when I try to get the sum([cost]) I
get a number with many decimal zero's all my cost field in the query are
single and have decimal property set to three. Any ideas why I am getting
such a long number after using the Sum() function? Pleaase advice.


You have to apply the format to the display object. Since the queries'
results are being displayed in a report you have to set the format of
the Sum(Cost) TextBox to Currency, or whatever format you want.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.