P
Pickymiss
I have all personnel records in one table coded by job function. I need to
break the managers from the list of people and make the list of people new
fields in the same table... or something like that! Some managers have one
report, others have 30+.
So I would want the table to be
Manager, manager's info, direct report (DR) 1, DR 1's info, DR2, DR2's info,
etc.
I need to use it to pull data for an automated e-mail message in a mail
merge. I tried to build a query, but failed miserably. Unless there is a
way to pull from a sub set of records in a second table for a mail merge, I
am stuck. I could build the two tables with select queries.
If it were just an on-screen form, I could do it, but I actually need to
pull the fields from one table and send all the information on one department
to the manager (including all the direct reports).
Any suggestions?
break the managers from the list of people and make the list of people new
fields in the same table... or something like that! Some managers have one
report, others have 30+.
So I would want the table to be
Manager, manager's info, direct report (DR) 1, DR 1's info, DR2, DR2's info,
etc.
I need to use it to pull data for an automated e-mail message in a mail
merge. I tried to build a query, but failed miserably. Unless there is a
way to pull from a sub set of records in a second table for a mail merge, I
am stuck. I could build the two tables with select queries.
If it were just an on-screen form, I could do it, but I actually need to
pull the fields from one table and send all the information on one department
to the manager (including all the direct reports).
Any suggestions?