Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-09-2008, 12:28 PM
Tom Pickles Tom Pickles is offline
Novice
Combine Records when Mail Merge from Access
 
Join Date: Sep 2008
Posts: 2
Tom Pickles is on a distinguished road
Default Combine Records when Mail Merge from Access

I have a parking permit database. You have can have a max of two cars on one permit. The way I have set it up is one table for users, one for cars. A second table for permit id inc user and date info. Then a 4th table linking the cars with the permit. that 4th table has composite keys as obv the permit ID here isnt unique.



So, when I mail merge, the database spits out permit id, expiry date and car reg according to this 4th table.

however i want the final format on the printed permit to be:

"permit id", "expire date", "car reg 1 / car reg 2"

any clues please?!
Reply With Quote
  #2  
Old 09-09-2008, 03:01 PM
Tom Pickles Tom Pickles is offline
Novice
Combine Records when Mail Merge from Access
 
Join Date: Sep 2008
Posts: 2
Tom Pickles is on a distinguished road
Default

qry_PermitPrintDetail
Permit ID Expiry Date Zone Registration Number
1 30/09/2009 ALL KE06JFN
1 30/09/2009 ALL RICH
2 30/09/2009 CPARKS JE06 TKH
3 05/09/2007 ALL G6 777
3 05/09/2007 ALL JE88 GGJ
4 28/09/2008 CPARKS KE06 YHF

Basically, i want my mail merge to show like:
1, 30/09/2009, ALL, KE06JFN/RICH
2, 30/09/2009, CPARKS, JE06 TKH
3, 05/09/2007, ALL, G6 777/JE88 GGJ
Reply With Quote
  #3  
Old 08-24-2010, 06:00 PM
peter peter is offline Combine Records when Mail Merge from Access Windows XP Combine Records when Mail Merge from Access Office 2007
Novice
 
Join Date: Aug 2010
Posts: 2
peter is on a distinguished road
Default when you get an answer, please forward

I am doing the same thing but want one client to have multiple documents (two access tables) i will forward answers if i have them...
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Query kangabanga Mail Merge 0 09-25-2008 04:07 AM
Merge mail not working jdpowell@brazoriainet.com Mail Merge 1 07-25-2008 07:51 PM
mail merge in word help jngovols Mail Merge 0 04-07-2008 05:40 AM
Word / Access - Mail Merge ibuilders Mail Merge 0 07-30-2007 06:18 PM
Combine Records when Mail Merge from Access Access 2003 query with wildcards into Word 2003 mail merge Poingdexter Office 1 10-30-2005 06:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:06 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft