I have a table that has multiple rows for one employee.
I would like to combine them into one row.
EmployeeID, Firstname, Lastname, plan description, plan Category
ID1, John, Smith, Delta dental, Single
ID1, John Smith, Life insurance, Basic
ID1, John Smith, Long term disablity, 2/3Salary
ID2, Mary, Olson, Delta dental, family,
ID2, Mary, Olson, Preferred one, Single.
I would like to put each employee into one row.
EmployeeID, Firstname, Lastname, plan description1, plan Category1,plan description2, plan Category2, plan description3, plan Category3
It would be better to create several tables, one for the Employees, one for the Plans (with a PlanID) and a third that would link Employees and Plans and would only contain pairs of EmployeeID - PlanID.
With your system, what happens when an employee has more plans than your table has columns to store them?
There isn't a subreport in a WORD mail merge... well actually there might be but I am unaware of it... I was referring to ACCESS reports and subreports. There is almost no reason to use Word to do a mail merge with an Access database when Access reports do essentially the same thing by default design.