how sum values with comma?

  • Thread starter Thread starter Ian Elliott
  • Start date Start date
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!
 
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.
 
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...
 
Back
Top