Mail Merge Formatting

[ajolson1964]

I am having a problem keeping formatting after a mail merge has completed. Here is the issue.

I have formatted in access a field as a percent. In access I see 50%. But when I mail merge it, to a word document reads .50 does anyone know how to make word read as 50%?

Thanks’
Andy

 

[PHV]

Use a formatting query, eg:
SELECT Format([yourField],"PERCENT") AS aliasName, ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ajolson1964]

Where do I type that in? A new query or in "OnClick" of the command button that mergeges the table with the word document?