merging currency to publisher

[malcolmmabe]

i'm having probs merging data to from acces to publisher

i have 3 currency fields, cost, vat and total cost(cost
+vat). vat = cost*0.175. this is stored ok as
currency in access, but when it's merged to a publisher
document, it's converted into a normal number, i.e 3
decimal places. any ideas?

 

[Allen Browne]

Create a query into this table.
In the Field row of query design, enter fields like this:
cCost: Format([Cost], "Currency")
Then use export this query to Publisher instead of the table.

The results of the query are now treated as text in Access (so not good for
maths operations), but the text will be formatted and exported correctly for
Publisher.