Different formats in a concatenated field

[Tracy]

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

 

[Rick Brandt]

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

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

EX:

=[SomeTextField] & " " & Format([SomeCurrencyField] "Currency") & ...

 

[Tracy]

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

EX:

=[SomeTextField] & " " & Format([SomeCurrencyField] "Currency") & ...

Thankyou so much!!