how sum values with comma?

[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!

 

[KARL DEWEY]

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

 

[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!

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.

 

[Ian Elliott]

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

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!

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.