Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Currency format question...

Status
Not open for further replies.

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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top