Problem with properties when merging to Word

P

Paul

Hello,

I have made a mailmerge with a query as the source. There are some
calculated fields. When running the query in Access I get for example the
result € 5,00 or € 5,50. Merging to Word the value becomes € 5 or € 5,5 in
the merged document.

Please help!

Thanx

Paul
 
K

Ken Sheridan

Format the computed column as text in the query. As this seems to be
currency data you should be able to do it with something like:

SELECT
OrderNumber, OrderDate, Customer,
Format(Amount * (1 + VATRate),"Euro") As GrossAmount
FROM Orders
ORDER BY OrderDate;

Or you can use a customized format expression in place of "Euro".
 
D

Douglas J. Steele

Use the Format function on your calculated fields to convert them into
appropriate strings.
 
Top