Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-06-2013, 02:18 AM   #1
0nyx175
Newly Registered User
 
Join Date: Aug 2012
Posts: 26
Thanks: 1
Thanked 1 Time in 1 Post
0nyx175 is on a distinguished road
side by side for mail merge

Hi guys,

I have the following table

NINo - AccNo - Saving
AAAA - 1234567890 - 10
AAAA - 2222222220 - 50
AAAA - 4554545454 - 60
CCCCCC - 4981451191 - 10
DDDDDD - 9841918951 - 55
AAAA - 9878978979 - 10
DDDDDD - 6541651511 - 10

I need to merge it (see template attached) so ideally i'd need to take the above table and format it as follows

NINo - acc 1 - saving 1 - acc 2 - saving 2 - acc 3 - saving 3 - acc 4 - saving 4

Can anyone suggest a solution? Database and merge document attached
Attached Files
File Type: accdb Database1.accdb (456.0 KB, 39 views)
File Type: doc Merge.doc (28.0 KB, 65 views)

0nyx175 is offline   Reply With Quote
Old 08-06-2013, 10:47 AM   #2
Cronk
Newly Registered User
 
Join Date: Jul 2013
Posts: 2,075
Thanks: 3
Thanked 451 Times in 444 Posts
Cronk will become famous soon enough Cronk will become famous soon enough
Re: side by side for mail merge

It seems you want to generate a report, not merge data.

Put the details about the individual accounts in a sub report and link on the customer name.

Incidentally, what determines which account for AAAA is account 1? Or does it not matter?
Cronk is offline   Reply With Quote
Old 08-07-2013, 02:33 AM   #3
0nyx175
Newly Registered User
 
Join Date: Aug 2012
Posts: 26
Thanks: 1
Thanked 1 Time in 1 Post
0nyx175 is on a distinguished road
Re: side by side for mail merge

I was thinking something more along the lines of a cross-tab query but can't work it out. The report acts like the query in that it does the folowing:

NINo - AAAA
1234567890
2222222220
9878978979
4554545454

I cant mail merge the above

It doesnt matter which account for AAAA is account 1.

0nyx175 is offline   Reply With Quote
Reply

Tags
mail merge

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Viewing data side-by-side for different criteria Swatkins Queries 2 10-26-2012 12:31 PM
1 pivot table 2 queries show graphs side by side? dboulton Queries 0 12-02-2010 11:50 PM
HELP! Single Column Query Results to Flow Side-by-Side using MS Access psimpson Reports 3 12-17-2009 06:09 AM
Showing multiple values from a field side by side MickeyGreen Reports 2 05-23-2005 10:24 AM




All times are GMT -8. The time now is 08:55 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World