Concatenation and Currency

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 fields in my book database, Condition and Price. I have the Price
field set as Currency. However when I join the two fields in my report, the
price displays as a number, e.g. 6.5 instead of $6.50. I am using the
expression, =[Condition]&" "&[Price].

Where am I going wrong?

Thanks.
 
I have 2 fields in my book database, Condition and Price. I have the Price
field set as Currency. However when I join the two fields in my report, the
price displays as a number, e.g. 6.5 instead of $6.50. I am using the
expression, =[Condition]&" "&[Price].

Where am I going wrong?

Thanks.
Click to expand...

Once a number field is concatenated with a text field, the number
field looses whatever number format it has, as it is now text.

=[Condition] &" "& Format([Price],"Currency")
 
Back
Top