G
Guest
I need to build a report getting the data from more than one table or query,
how can I do that.
how can I do that.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
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.
one table or query" can be combined into a single query then you might not
need subreports.
G
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.
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.
D
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.
Then tell us how you want to display these records on your report.
P
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.
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.