Grouping from Multple Quiries or Tables in Reports

[Guest]

Hello -- I am using Access 2002 I need to create a report that can list
details of services rendered for each person. My DB is setup like this:
tbl:Consultant tbl:Estimates tblerformed tbl:Customer tbl:Location. In
my report I need to group by Consultant Name and for each consultant I need
to list the tbl:Customer.Customer Name, tbl:Location.Location,
tbl:Estimates.Description and tblEstimates.Cost or tblerformed.Cost. The
trouble I am having is that there is a Cost in tbl:Estimates and in
tblerformed, where there are 10 values in estimates and 4 in performed,
with 14 total entries. There is a common Service ID in tbl:Estimates and
tblerformed and tblerformed does not have Service IDs that are not in
tbl:Estimates. Currently consultants that are in tbl:Estimates are not the
same as those in tblerformed.

Any help or guidance would be very much appreciated!!!

 

[Duane Hookom]

I doubt you can create a single record source query. You may need to create
a subreport for Estimates and place it in a header or footer of another
group.