I have a report that will print out info from a query. That query is based on 4 tables that are linked together. Basically, I have a table with name and address and so-on. The next table that is linked to it is for property accociated with that person. So their is one person, but that person can have several items of property associated with them. Example Jon Doe(One Record) He owns a stero, dvd player, vcr (3 records) On my report I can only get it to show the first item of property entered in the table. How can I get it to show multiple items of property. Hopefully this makes sense.
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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Multiple records on report
- Thread starter esu4edp
- Start date
On your quesry definitions, double click on the relationship lines and set the join types appropriately. Probably what is happening, is that you are only retrieving those rows where all four tables have matching key records.
Hope this helps, Cheers,
Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
Hope this helps, Cheers,
Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
- Thread starter
- #3
Ok that made it appear, however, on the report it makes a seperate page for each record. For example, for each record in property, it is printing the whole report on different pieces of paper. So each record prints out on seperate pieces of paper along with the other records from the other tables (this information is the same).
I don't know how you have set up your report, but here are a few things to look out for:
(a) Maybe try generating your report using the report wizard.
(b) In Design View, use the File, Page Setup option, PAge tab to set the layout to Landscape.
(c) Ensure that the width of the page does not exceed the size of a landscaped A4 page. Do this by sizing your controls to be smaller, and dragging them left. Then reclaim the unused page space by putting your cursor on the right boundary, and when the single arrow changes to a double horisontal arrow, drag left, until the page dimensions are within the A4 allowable size.
Hope this helps. Best advise however is to get hold of an intro book on Access. This will lead you through all of the fundamentals.
Let me know how you're progressing Cheers,
Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
(a) Maybe try generating your report using the report wizard.
(b) In Design View, use the File, Page Setup option, PAge tab to set the layout to Landscape.
(c) Ensure that the width of the page does not exceed the size of a landscaped A4 page. Do this by sizing your controls to be smaller, and dragging them left. Then reclaim the unused page space by putting your cursor on the right boundary, and when the single arrow changes to a double horisontal arrow, drag left, until the page dimensions are within the A4 allowable size.
Hope this helps. Best advise however is to get hold of an intro book on Access. This will lead you through all of the fundamentals.
Let me know how you're progressing Cheers,
Steve Lewy
Solutions Developer
steve@lewycomputing.com.au
- Status
Similar threads
- Locked
- Question
- Locked
- Question