combining rows of data

[Miskacee]

I have 2 fields, (1) EE (2) goal
I may have 3 rows of data with the same (1) EE
How can I combine all 3 rows of data with the same EE into one row? In
other words, combine the (2)Goals into one row of data with a ; between each
goal but have only one row of data with only one (1) EE?

Thank you so much.

 

[Beetle]

You shouldn't.

If one EE can have more than one Goal, then Goals should be in a
separate table, in a 1:m relatioship.

 

[pietlinden]

I have 2 fields, (1) EE (2) goal
I may have 3 rows of data with the same (1) EE
How can I combine all 3 rows of data with the same EE into one row?  In
other words, combine the (2)Goals into one row of data with a ; between each
goal but have only one row of data with only one (1) EE?

Thank you so much.

try fConcatChild, which is here...
either...
http://www.mvps.org/access/modules/mdl0008.htm
or...
http://www.mvps.org/access/modules/mdl0004.htm

 

[Miskacee]

That is not the issue. I have data coming from a separate system with 2-20
rows of 'goals' per employee. We are making a change so employees can non
longer enter 20 rows of goals but only have one field for a goal.

I am trying to combine those 2-20 rows of goals into one row of goals,
having a ; to divide the goals. One employee name per row with 2 or more
goals listed.

 

[Miskacee]

I will try this. I figure I may have to add the same table to one query and
try and get the rows.