 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / March 2008Multiple tables 1 report
I have a need to include 5 different tables in one report. I created a query but it would not allow multiple links in one query, so I created multiple queries useing the preveious query with the next table. It worked good till I added the last query to include the last table. This query will not populate, as if there is a limit to how many times this can be done. What would be the best way to include this many tables into one report? I thought maybe sub reports, but this would limit how the report is organized. Any Thoughts? Did you make relationships to each of the tables? > I have a need to include 5 different tables in one report. I created a query > but it would not allow multiple links in one query, so I created multiple [quoted text clipped - 3 lines] > best way to include this many tables into one report? I thought maybe sub > reports, but this would limit how the report is organized. Any Thoughts? yes, all tables have relationships. > Did you make relationships to each of the tables? > [quoted text clipped - 5 lines] > > best way to include this many tables into one report? I thought maybe sub > > reports, but this would limit how the report is organized. Any Thoughts? Try to create a union query that will open them. You will have to set the Relational field as the primary. Please send a little more info on the query. also tell what is the relationship. > yes, all tables have relationships. > [quoted text clipped - 7 lines] > > > best way to include this many tables into one report? I thought maybe sub > > > reports, but this would limit how the report is organized. Any Thoughts? I've often stacked queries on queries on queries etc especially when I want multiple left joins (Show all the customers, even if they haven't got an order, show all the items even if no-one has ordered them. Put the lot into a crosstab showing all the months in the column header even if no-one has placed any orders on some months). Those left joins get very picky about what other links you can do when they are present. I've not come across a 'stacking' restriction yet. Is it that you have lots of joint primary keys and they are now causing problems or are the tables not linked by a common field? Evi > I have a need to include 5 different tables in one report. I created a query > but it would not allow multiple links in one query, so I created multiple [quoted text clipped - 3 lines] > best way to include this many tables into one report? I thought maybe sub > reports, but this would limit how the report is organized. Any Thoughts? To the both of you, I appreciate your interest to help. The questions and statements you made had me looking at it in a different light and I realized I had the join properties wrong in the query. After fixing this everything worked. Thanks agian. (sometimes we just need a break!) > I've often stacked queries on queries on queries etc especially when I want > multiple left joins [quoted text clipped - 20 lines] > > best way to include this many tables into one report? I thought maybe sub > > reports, but this would limit how the report is organized. Any Thoughts? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.