how sum values with comma?

I

Ian Elliott

Thanks in advance for any help.
I have a query, with:
BUCKET_VALUE: Sum(Round([SumOfBUCKET_VALUE],2))
and I would like to have a comma displayed in between the thousands and
hundreds, for example:
9,546.00

not just:
9546.00
Because some of the numbers are large, and there's alot of them.
Any ideas?
Thanks very much!
 
K

KARL DEWEY

Try this --
BUCKET_VALUE: Format(Sum(Round([SumOfBUCKET_VALUE],2)), "#,###.00")
 
J

John W. Vinson

Thanks in advance for any help.
I have a query, with:
BUCKET_VALUE: Sum(Round([SumOfBUCKET_VALUE],2))
and I would like to have a comma displayed in between the thousands and
hundreds, for example:
9,546.00

not just:
9546.00
Because some of the numbers are large, and there's alot of them.
Any ideas?
Thanks very much!
Click to expand...

Don't confuse data STORAGE with date DISPLAY. They are different functions!

You should not be using query datasheets for displaying or editing data;
instead base a Form (for onscreen display) or Report (for printing) on the
query. Set the Format property of BUCKET_VALUE to "Currency" or to "#,##0.00"
or to any format you like. The calculation will calculate, and the format will
control how the result is displayed.
 
I

Ian Elliott

Thanks to Karl and John. I did the format one, just because it's easier than
writing a form. Thanks alot!


John W. Vinson said:
Thanks in advance for any help.
I have a query, with:
BUCKET_VALUE: Sum(Round([SumOfBUCKET_VALUE],2))
and I would like to have a comma displayed in between the thousands and
hundreds, for example:
9,546.00

not just:
9546.00
Because some of the numbers are large, and there's alot of them.
Any ideas?
Thanks very much!
Click to expand...

Don't confuse data STORAGE with date DISPLAY. They are different functions!

You should not be using query datasheets for displaying or editing data;
instead base a Form (for onscreen display) or Report (for printing) on the
query. Set the Format property of BUCKET_VALUE to "Currency" or to "#,##0.00"
or to any format you like. The calculation will calculate, and the format will
control how the result is displayed.
Click to expand...
 
Top