Reports using a detail table

  • Thread starter Thread starter Howard
  • Start date Start date
H

Howard

What's involved in working a sub-table into a report. I
have a labour table with tasks for a given job. For each
task record, I may have several resources working on that
task. The resource records, which have fields such as
resource name, hours worked, and rate, are kept in a
separate table with a many-to-one relationship. In this
report, for a given job, I need to print all of the tasks,
and under each tasks, all of the resource records for that
task. Can you have a hierarchy of detail sections in a
report? How do I accomplish what I need? Please let me
know. Thanks!
-Howard
 
If you've made a form with a subform, the procedure is similar.

Create another report based on the many table. Drag and drop this report
into the detail section of your current report, right below the current
controls for the tasks. Link the Master/Child fields of the main report and
sub report to the field that links the two tables. When you run the report,
the subreport will fill with the records associated with the current task in
the detail section.
 
Brilliant!!! Thanks!
-Howard
-----Original Message-----
If you've made a form with a subform, the procedure is similar.

Create another report based on the many table. Drag and drop this report
into the detail section of your current report, right below the current
controls for the tasks. Link the Master/Child fields of the main report and
sub report to the field that links the two tables. When you run the report,
the subreport will fill with the records associated with the current task in
the detail section.

--
Wayne Morgan
Microsoft Access MVP





.
Click to expand...
 
Back
Top