Grouping from Multple Quiries or Tables in Reports

B

binder

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 tbl:performed 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 tbl:performed.Cost. The
trouble I am having is that there is a Cost in tbl:Estimates and in
tbl:performed, 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
tbl:performed and tbl:performed 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 tbl:performed.

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Multi level grouping in a report 2
Count Number of Subgroups in Group Header 3
Report only displaying some info 1
Report Grouping 4
SQL data from VBA - Sort into groups via heading. 7
Report design 6
Display Dynamic # of Rows in SubReport 0

Top