Access - Combining Data from rows

  • Thread starter Thread starter A Mackay
  • Start date Start date
A

A Mackay

Don't know if this is possible @ all, as from searching
the newsgroups I can't find a particular article that is
requesting this.

I have two tables as per below:

Problems:
PL #, Description, Type, Problem Owner

Countries:
Original, Impacted Countries

The two tables are linked through the PL # which exists in
both tables.

Due to one Problem potentially having multiple 'Impacted
Countries' the data will appear as per below:

PL1, Test Decription, Tech, A Mackay, England, France
PL1, Test Decription, Tech, A Mackay, England, Germany
PL1, Test Decription, Tech, A Mackay, England, Italy

Therefore a new row will come out for each 'impacted
countries' field against a PL.

Is it possible to have the data combine, as per example
below:

PL1, Test Decription, Tech, A Mackay, England, France;
Germany; Italy

Appreciate your help on this - Many Thanks, Al (
(e-mail address removed) )
 
Back
Top