Complicated Mail merge issues 2

[maverickmonster]

I have an access database with approximately thirty tables in it. A user can have personal Information in some / all of the screens and maybe more than one record in each.

I want to print out all the information that relates to each user (each table is related to a main table by a Unique ref number).

I was thinking about making a query for each table to pull out the relevant information, then printing all the report that had information in.

I have had a test run on a couple of tables but looks really bad the way that there is a load of wasted space. Is there anyway to combine all these reports to print a nicer looking one?

I have tried to publish to word and looks ok with some formatting, but i can conditionally publish these?! I have tried a merge but when you need display say three records it shows one set of results over three letters rather than in a table as required.

Can any one suggest a way i can conditionally merge on queries to a word doc in a table format?!

Thanks in advance

Maverick monster

 

[maverickmonster]

I am nearing completion of my reports

Everything is going well but the only thing that looks bad is that when a report gets splits over two pages it there anyway to keep the report together on next page rather than splitting it up ?

Cheers

 

[dhookom]

There are properties that you can set to keep sections together.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[maverickmonster]

Have found this think this is what i need to do

http://support.microsoft.com/?kbid=208541