I have a main table with about 1400 records. These records are distinguised by a department code. I want to print a seperate report for each department code. How do I do this with a macro? Can anyone help me?