Report Footing

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

I'm trying to use the following expression as the
ControlSource of a text box in the footer of a
report.

="Payments ( " & Format(Sum([PaymtAmount]),currency) & " )"

I thought I understood correctly that one could use the
term "currency" as the format specification for the Format
function. But, Access puts [] around it and I'm asked for
the parameter value for currency at runtime.

The summation works to the extent of the numeric value
being correct, but I need it to inherit the format properties
of "PaymtAmount" that appears in the Detail section of the
report.

What am I missing?

Bill
 
I used "$##,###" in place of what I thought a valid
keyword to Format and the problem went away.
I'd still like to know where my understanding went
afoul regarding the use of a keyword for currency.

Bill
 
Yes, and/or as I posted earlier:
="Payments ( " & Format(Sum([PaymtAmount]),"$##,###") & " )"
Where the data will range in whole dollars from $0 to $99,999
Thanks,
Bill

Duane Hookom said:
Apparently you need to use:
="Payments ( " & Format(Sum([PaymtAmount]),"$0.00") & " )"
--
Duane Hookom
Microsoft Access MVP


Bill said:
I'm trying to use the following expression as the
ControlSource of a text box in the footer of a
report.

="Payments ( " & Format(Sum([PaymtAmount]),currency) & " )"

I thought I understood correctly that one could use the
term "currency" as the format specification for the Format
function. But, Access puts [] around it and I'm asked for
the parameter value for currency at runtime.

The summation works to the extent of the numeric value
being correct, but I need it to inherit the format properties
of "PaymtAmount" that appears in the Detail section of the
report.

What am I missing?

Bill
Click to expand...
Click to expand...
 
Bill said:
I'm trying to use the following expression as the
ControlSource of a text box in the footer of a
report.

="Payments ( " & Format(Sum([PaymtAmount]),currency) & " )"

I thought I understood correctly that one could use the
term "currency" as the format specification for the Format
function. But, Access puts [] around it and I'm asked for
the parameter value for currency at runtime.

The summation works to the extent of the numeric value
being correct, but I need it to inherit the format properties
of "PaymtAmount" that appears in the Detail section of the
report.

What am I missing?
Click to expand...

The word currency needs quotes around it.
 
Back
Top