Error in merging queries to Word after upgrade from 97 to XP

[JW]

A 97 access database which has a number of queries to show
how much of various amounts are VAT eg "Rate VAT: [Total
Rate]*17.5/117.5" worked perfectly well in Access 97 and
the results were merged to various Word documents as
invoices, daily reports etc. in the correct format and
decimal places eg £11.17

After upgrading the calculations still appear to be
working in the queries as the resulting tables correctly
display amounts as above ie £11.17

However, when these are now merged to Word XP they will
only display as 11.1702127659574 (!?)

If you ROUND the calculation in the query the resulting
table still displays accurately £11.17 but the resulting
merged document will only display as 11.17 ie without the
currency symbol (!!??)

Obviously it is possible in the Word document to add a £
symbol but ... this is going to be a lot of additional
work, ie all the existing queries with this calculation
will have to be ROUNDed and then all the existing merge
documents will have to have the new field names added and
the £ sysmbol added.

Why is the happening?

Why would it change between 97 and XP?

JW

 

[Michel Walsh]

Hi,



Try to use, in your query, something like:

SELECT Format( [Rate VAT], "currency" ) FROM ...


The format will export a string, formatted to the current setting of
"currency".


Hoping it may help,
Vanderghast, Access MVP