PaulChilds
Technical User
- May 21, 2002
- 195
I have a report which gets its details from a query.
I have concatenated two of the fields into one text box using the following code:
=[Installment] & " (" & [Installment (In Words)] & "
"
However, [Installment] needs to be in currency format and [Installment (In Words)] needs to be text.
Is there any way to do this apart from having two seperate text boxes?
Paul C
I have concatenated two of the fields into one text box using the following code:
=[Installment] & " (" & [Installment (In Words)] & "
However, [Installment] needs to be in currency format and [Installment (In Words)] needs to be text.
Is there any way to do this apart from having two seperate text boxes?
Paul C