Sums in a Query

  • Thread starter Thread starter Kathy Webster
  • Start date Start date
K

Kathy Webster

I have [AmountPaid] in a totals query. Of course, it is stripping out the
decimal and 00 cents
(25.00 is changing to 25)

I know how to make it "look" right using
Ccur(Format([AmountPaid],"standard") or
Cstr(Format([AmountPaid],"standard"), but I need it to retain it's value,
because it is then saving out to Excel.

I am told I am not allowed to have the dollar sign in Excel, either.

TIA,
Kathy
 
the Totals in query is a calculated value? If so, are the fields in the
table, that are being calculated to find the Total in the query, are these
Table fields formatted as Currency fields with 2 decimal?
 
Kathy said:
I have [AmountPaid] in a totals query. Of course, it is stripping out the
decimal and 00 cents
(25.00 is changing to 25)

I know how to make it "look" right using
Ccur(Format([AmountPaid],"standard") or
Cstr(Format([AmountPaid],"standard"), but I need it to retain it's value,
because it is then saving out to Excel.

I am told I am not allowed to have the dollar sign in Excel, either.
Click to expand...


But 25 and 25.00 are the same value. I think you are really
saying that you want to format the numbe to display the .00
part. Personally, I think this should be done by formatting
the cells in the Excel worksheet, but you can do it in the
query by setting the field's Format property to 0.00 or by
using a calculated field with the expression:
Format([AmountPaid],"0.00")
 
Thank you. I had no idea you could set the format property in a query field.
The simplest answer is the best.
Amazing the hoops I have been jumping through for years...

Marshall Barton said:
Kathy said:
I have [AmountPaid] in a totals query. Of course, it is stripping out the
decimal and 00 cents
(25.00 is changing to 25)

I know how to make it "look" right using
Ccur(Format([AmountPaid],"standard") or
Cstr(Format([AmountPaid],"standard"), but I need it to retain it's value,
because it is then saving out to Excel.

I am told I am not allowed to have the dollar sign in Excel, either.
Click to expand...


But 25 and 25.00 are the same value. I think you are really
saying that you want to format the numbe to display the .00
part. Personally, I think this should be done by formatting
the cells in the Excel worksheet, but you can do it in the
query by setting the field's Format property to 0.00 or by
using a calculated field with the expression:
Format([AmountPaid],"0.00")
Click to expand...
 
Back
Top