multiple data sources

[Guest]

I need to build a report getting the data from more than one table or query,
how can I do that.

 

[Duane Hookom]

You can create a main report with more than one subreport. If the "more than
one table or query" can be combined into a single query then you might not
need subreports.

 

[Guest]

I have been trying to build a query like that. I actually have another post
on the query site about that problem mabe you can help. I have a query
pulling data from 3 tables. reservations, reservation details and payments.
there are 176 records in the reservation table but when I run the query only
80 of them show up. The query is using resid group by and a number of other
fields in other tables also using group by.

 

[Duane Hookom]

You need to take the time to describe your tables and their relationships.
Then tell us how you want to display these records on your report.

 

[Pat Hartman\(MVP\)]

1. You are using an inner join, which is the default, and you probably need
to use a left join.
2. It is unlikely that you will produce correct results with this join
unless there is NEVER more than a single payment for a reservation. Queries
can join multiple tables without a problem but they need to either be
related hierarchically or be lookup tables. In your case, you have two
separate 1-m relationships. Reservations-Details and Reservations-Payments.
Joining these three tables will produce a Cartesian product.