 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / May 2004Help with Mail Merge
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. 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  SignaturePlease 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 [quoted text clipped - 5 lines] > 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.