Create Report from multiple tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Put all specialist in the same table and add a field to differentiate them
in some way.
 
Your structure is wrong. all these records should be in one tabel. You
should add a field to indicate who the "specialist" is.
 
Back
Top