Help with Mail Merge

[COLECIOA]

I am using an acces query to merge into a word document. I have run into a problem when merging the fields wich contain combo boxes. When I complete the merge process my finished document shows the ID column instead of the column I wish to show.
Combo Box contains the Rank Cap column showed bellow and is used to fill data under the Rank column of my primary database.

ID RANK CAP RANK ABBREVIATIO
1 CORPORAL Corporal CP
2 SERGEANT Sergeant SG
3 STAFF SERGEANT Staff Sergeant SSG
4 GUNNERY SERGEANT Gunnery Sergeant GYSG

The merge field looks like «RANK» «FIRSTNAME» «MI» «LASTNAME» «SSN»
When I merge the query the result is 1 Antonio Colecio 123 45 678
For the merge field «RANK» it merges the ID column. My query shows the Rank Cap.
How could I change it so It could show the rank cap once it is done merging.

 

[Doug Robbins - Word MVP]

Hi Antonio,

It seems obvious that Access is storing the ID in that field and it has some
internal mechanism to display the text in queries and the like.

You could try enclosing that field in the Format() function in the query and
see if that forces it to display (and make available the text). Otherwise,
I think that this is an Access issue for which you may be more likely to
find someone to help you if you post to microsoft.public.access.queries

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

I am using an acces query to merge into a word document. I have run into a

problem when merging the fields wich contain combo boxes. When I complete
the merge process my finished document shows the ID column instead of the
column I wish to show.

Combo Box contains the Rank Cap column showed bellow and is used to fill

data under the Rank column of my primary database.

ID RANK CAP RANK ABBREVIATION
1 CORPORAL Corporal CPL
2 SERGEANT Sergeant SGT
3 STAFF SERGEANT Staff Sergeant SSGT
4 GUNNERY SERGEANT Gunnery Sergeant GYSGT

The merge field looks like «RANK» «FIRSTNAME» «MI» «LASTNAME» «SSN»
When I merge the query the result is 1 Antonio Colecio 123 45 6789
For the merge field «RANK» it merges the ID column. My query shows the Rank Cap.
How could I change it so It could show the rank cap once it is done

merging.