Hi, every1,
I have a table with a field of numbers (PmtReceived) and another field with the currency (CUR). The latter can be USD for US dollars or EUR for euros.
I would like to join these two fields into a single one (in a report) with CUR + PmtReceived and I have tried millions of things to no avail.
Example:
CUR VALUE = JOINED NEW FIELD
USD 2,000.00 = USD 2,000.00
Thanks in advance for any suggestion!
lbcarvalho