Looking for a way to use a table called Tbl_Divisions that has DivisionID and Division Total. A table named Tbl_AddressBook that has Division, Cost Center, Emplid, EmpName, and other information. I need a report created for each line within the Tbl_Divisions by DivisionID From the Tbl_AddressBook. and then total the number of team members and total number of teams from that table.
I want to put this on a form as a button so it when I click on the button it will kick off and create all individual division reports from the Tbl_AddressBook without anyone having to select each one. I would appreciate the help.