Report Footing

[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

 

[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

 

[Duane Hookom]

Apparently you need to use:
="Payments ( " & Format(Sum([PaymtAmount]),"$0.00") & " )"

 

[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

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

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

 

[Rick Brandt]

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?

The word currency needs quotes around it.