Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by carrick
-
merge to word shows primary key instead of value
From what I can see, you have a couple of problems. 1) The first SQL statement only contains information from your [Master Addresses] table. As per your information in the earlier post, this table only stores the primary key number for the city, etc. Therefore, this is the only thing that it...- carrick
- Post #6
- Forum: Microsoft: Access Other topics
-
merge to word shows primary key instead of value
Can you post the SQL for your query. It may be the join type is incorrect.- carrick
- Post #4
- Forum: Microsoft: Access Other topics
-
merge to word shows primary key instead of value
Hi jazminecat, The query that you use to merge into Word needs to include both tables, the master address table and the CitiesTable. When you add the two tables to the query, the join line should be present indicating how the two tables are joined. If the line doesn't appear, the relationship...- carrick
- Post #2
- Forum: Microsoft: Access Other topics
-
Running queries called by macro through form
I'm not sure I fully understand all your steps, but it seems the reference within the query is incorrect. If you use ME to reference a control, you are meaning a control within the same item (in this case, the query). The FORMS collection is what you want to use instead. I think [Forms]