D
default105
Access 2k, WinXP
I have a need to print a report for each person in our shop. It lists the
orders that they have assigned to them. However the manager of the
department does not want to have to select each individual person from a
combo box to print what that person has on there list. He just wants to pick
the department and have the report print out a report for person A, Person B,
Person C and so on but not all group together on one report. I know this can
be done but I don't know how to set up the form to print a report for person
A then requery then print person B, requery then print person C from a form
where he can pick the department then click print. Do you have to use a
Do...Loop in order to achieve this or can it be done from the report side
and have it page break when a new name is starting to print(if possible)? If
this is to vague please let me know and I will add more. Thank you all.
I have a need to print a report for each person in our shop. It lists the
orders that they have assigned to them. However the manager of the
department does not want to have to select each individual person from a
combo box to print what that person has on there list. He just wants to pick
the department and have the report print out a report for person A, Person B,
Person C and so on but not all group together on one report. I know this can
be done but I don't know how to set up the form to print a report for person
A then requery then print person B, requery then print person C from a form
where he can pick the department then click print. Do you have to use a
Do...Loop in order to achieve this or can it be done from the report side
and have it page break when a new name is starting to print(if possible)? If
this is to vague please let me know and I will add more. Thank you all.