MS Word using merge with Access-data

[Eef]

I created a MS Word document and want to use data from an Access-DB.

I use a field which is in Access of type Currency. In the Word document it represents as a normal numeric field.
Example:
Access shows € 45,50
Word shows this as 45,5

How can I present this data in Word also as Currency?

Eef

[June7]

Might have to use the Format function on the field to convert value to a string that includes the monetary symbol. This way the symbol will export with the data. Or include the symbol within the body of the Word document.

[Eef]

Might have to use the Format function on the field to convert value to a string that includes the monetary symbol. This way the symbol will export with the data. Or include the symbol within the body of the Word document.

Thanks for the answer. Just including the currency symbol is not enough. The value also needs 2 decimals.

[June7]

Concatenate.

"€ " & Format([field], "0.00")

If you want a fixed length string:

"€" & String(7 - Len(Format([field],"0.00"), " ") & Format([field], "0.00")

[Eef]

Concatenate.

"€ " & Format([field], "0.00")

If you want a fixed length string:

"€" & String(7 - Len(Format([field],"0.00"), " ") & Format([field], "0.00")

I think I found the final solution. It is NOT in Access but in Word where to solve this problem.

When merging Word with Access-data only the value stored in the db will be used. No formatting is involved. Unless you created a query with textfields for the purpose.

If you're in the main-docoment use Alt-F9. Then you see all the fields you are using, also the Access-fields. You are now able to attach editing/formatting info to the field.
In my case with the currency field it looks like this: {MERGEFIELD "<Fieldname>" \# €###0,0.0}
or for date fields: {MERGEFIELD "<Fieldname>" \@ DD-MM-yyyy}

[June7]

I've never done Access/Word mail merge so thanks for the followup info. But not sure what you mean by 'main-document' - what other document would there be?

However, the suggested expression should also work because it results in a text field in query. Use query as the data source for mail merge.

[Eef]

I've never done Access/Word mail merge so thanks for the followup info. But not sure what you mean by 'main-document' - what other document would there be?

However, the suggested expression should also work because it results in a text field in query. Use query as the data source for mail merge.

When you mail merge in Word you always have 2 resources:
1. a Word-document (the main-document) with text, figures, whatever and one or more fields from a second resource.
2. the second resource. This can be an Excel, Access document or even a table in another Word-document.