Nesting currency field in text string in a report

[Mordacia]

Hello,

I have a text string in a report where I want to include a currency field from a table. The table has 100 records. So far, my expression looks like this:

="The company contributes " & [ContributionAmount] & " per year for up to 10 years."

The [ContributionAmount] field is appearing as text instead of currency - it has no dollar sign or thousand separator. Could you tell me how to change the format of the field to currency? It is definitely a currency field in the table. I think I might need to use "@Currency" or the CCur(expression) but I'm not sure exactly how to do this.

 

[BanditWk]

I LOVE working with these!!!

Here's how you would fix your situation:

="The company contributes " & Format([ContributionAmount],"Currency&quot & " per year for up to 10 years."

It's all becoming proficient in Access.

Roy
aka BanditWk
Las Vegas, NV
roy@cccamerica.org
RLMBandit@aol.com (private)

 

[Mordacia]

Thanks Roy. It worked! Have a great day and a nice weekend.

 

[Guest_imported]

Hello,

The solution BanditWk suggested works...but how can we get rid of the decimal and zeros?

Thanks!!!

 

[BanditWk]

Ok, to remove the decimal and zeros and maintain the "," the line would be used like this:

="The company contributes $" & Format([ContributionAmount],"Standard&quot & " per year for up to 10 years."

Standard will include the comma, I believe, but you have to put the dollar sign inside the quotes prior to the field formatting. I believe.

Roy
aka BanditWk
roy@cccamerica.org
RLMBandit@aol.com (private)

 

[67peshawar294]

Maybe try $#,### in the format line of the [contributionamount]