Create Report from multiple tables

A

AcousticBruce

Access 2003 I have separate tables set up for different enrollment
specialists. I successfully created reports to total contacts, enrollments,
etc. How do I create a report to get totals from all the different
specialists to show totals for the whole department?

Thank You
 
D

Duane Hookom

Put all specialist in the same table and add a field to differentiate them
in some way.
 
R

Rick B

Your structure is wrong. all these records should be in one tabel. You
should add a field to indicate who the "specialist" is.
 
Top