I have a table with Department Numbers and names and need to create reports for each of the department numbers from the table. The reports are created from a personnel table and it would be by department number. I am working to automate the report creation versus someone having to select 200 separate department numbers.
Table one - TBL_Dept_List - DeptNo, DeptName, TotalTeam
Report has data in it along with the team member information with the DeptNo as the link.
Could use a little help Thank you.