Problem with properties when merging to Word

[Guest]

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

 

[Guest]

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".

 

[Douglas J. Steele]

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

 

[Guest]

ok, thanx a lot!

"Douglas J. Steele" schreef:

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