Report shows each detail in different pages

neideb

Registered User.
Local time
Today, 00:38
Joined
Oct 9, 2001
Messages
42
Pls, see if you can help me on this:
I have a client table with PrimaryKey, clientname, address, date of birth. Another table with PrimaryKey, phone numbers like Celular, work phone, home phone.
I want to show all these info in the same report page. I created a query with these two tables and if client has 4 telephone numbers i can see 4 lines, repeating the main table data and each phone in a different line. I created a report based on that query. So, when I print the report I get 4 pages. The reason why I created a separate table for phone numbers was because I did not want client to type each time the name of phones like home, work, etc. so in the form I created a subform with a list box so client can only open list box and select which type of phone he wants.
I accept any suggestion to help me solve this problem.
I am not sure if this is a query problem or report problem. Tks for your attention.:confused:
 
Have you any groupings defined on your report? If you group by employee and put their main details in the group header and the telephone numbers, etc in the detail you can then tell Access to start a new page after each employee in the group footer section for the employee.
 
DCrake, thank you, thank you, many thanks. I did exactly what you said and that is it. All main info like name, address. etc are in the client group and the phone categories are in the details. I print just one client each time because I type info and if needed be I ask to print a report for this client. Now I have to re-design layout of report and continue doing my job in Peace.
I use access 2007. Later on I may have another important question to post in forum.
 

Users who are viewing this thread

Back
Top Bottom