--- In ms_access@yahoogroups.com, "Roseller Ocampo" <[EMAIL PROTECTED]> wrote: > > Thank you for reading this question. > > I have two tables that looks like these: > > EMPLOYEES > EmpID Surname > 100 Smith > 200 Johnson > > PROJECTS > EmpID Project > 100 Road > 100 Bldg > 100 Hwy > 200 Bridge > 200 Tower > > Question: > I would like to have a resultant table that will look like this: > EmpID Project > 100 Road, Bldg, Hwy > 200 Bridge, Tower > > How will I do this please? Is this can be done via query or a > program module? Please point me to ideas or examples.
There are two ways to do this. The first and simplest one is to generate a report and group by "EmpID". The second one is a little more complicated and requires that you generate two tables. One table for employees and another on for projects. You need the EMPID field in both tables. You don't need to re-enter the data. It is a simple matter of making a new table and making sure that you don't have any duplicates regarding EMPID. Copy the structure of your exsisting table (Not the Data. Reset the new table so you cannot have any duplicates. Delete the project fields from the new table. Be careful and don't delete any thing from the old table at this point. Then run an append query from the old table to the new one. This will leave you with a record with one employee with a unique EMPID. You then join the two tables in a query with EMPID as the common field. This should now give you the result you are looking for. Dick Fr... >
