Report Footing

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
 
B

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
 
D

Duane Hookom

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

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
 
R

Rick Brandt

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?

The word currency needs quotes around it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top