Concatenation and Currency

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tedski - 28 Dec 2006 04:50 GMT

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.

Reply to this Message

fredg - 28 Dec 2006 06:23 GMT

> 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
[quoted text clipped - 4 lines]
>
> Thanks.

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")

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message