Different formats in a concatenated field

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

Guest

I am trying to create a letter based on a query with several different
calculated and formatted fields concatenated into a continuous paragraph.
The trouble is, currency is not formatting as currency (as it does in the
underlying query) and the account number is not maintaining the specific
format I am using (a dash is being suppressed). I am also having trouble
with a concatenated address field that uses a zip+four with a dash to
separate.

Any suggestions?

Thanks,
Tracy
 
Tracy said:
I am trying to create a letter based on a query with several different
calculated and formatted fields concatenated into a continuous
paragraph. The trouble is, currency is not formatting as currency (as
it does in the underlying query) and the account number is not
maintaining the specific format I am using (a dash is being
suppressed). I am also having trouble with a concatenated address
field that uses a zip+four with a dash to separate.

Any suggestions?

Thanks,
Tracy
Click to expand...

You have to use the Format() function inside your concatenation expression.

EX:

=[SomeTextField] & " " & Format([SomeCurrencyField] "Currency") & ...
 
You have to use the Format() function inside your concatenation expression.

EX:

=[SomeTextField] & " " & Format([SomeCurrencyField] "Currency") & ...
Click to expand...
Thankyou so much!!
 
Back
Top