Print report for multiple criteria by iterating through IDs - MS Access
I have created a report that I would like to print by pushing a button. I can do that, but I want it to print to pdf the report for each advisor. I'm not sure how to get it to iterate through and print the report for each advisor.
I have a list of advisors in a table, OR could it run through the query and print for each advisor as the number changes? Every advisor will not have data every time, however, if they do have data I want to print the report to pdf so I can email it to them.
I'm relatively new at this and I'm totally stumped - can anyone help me out??