Formatting concatenated field

[mike250]

Hello,

I have a report with a concatenation of text and a numeric field that I want to convert to currency. Here's an example:

Table Structure
===============
ID - Autonumber
Store - Text
Sales - Currency

When I insert the Sales field into the report by itself, it correctly formats as a currency field. However, when I concatenate with text it doesn't. Example:

='Total sales for this store was ' & [Sales]

It won't display as currency! I've also tried:

='Total sales for this store was ' & CCur([Sales])


Has anyone got any ideas?

 

[dhookom]

='Total sales for this store was ' & Format([Sales],"Currency&quot

Duane
MS Access MVP

 

[mike250]

Thank you sir.