I'm struggling with this, essentially what I want to do is this:
In a table of items and program no's there may be multiple records that have different program no's because they are made on different machines
Item Prog
1234 1234P1
1234 1234P2
1234 1234P3
In a report for a single Item I want to concatenate the three possible program No's into a single field 1234P1,1234P2, 1234P3
Any ideas please
Thanks
Ian