Build a String of Like fields

[DDBeards]

I have a table with two fields; OrgID and PosID. The OrgID is the
organization and the PosID is position titles. I would like to group the
records by OrgID, and list all the PosID found within that OrgID. I can do
that with a group query no problem; however what I need is to create both by
OrgID and PosID (2 seperate usages) two fields that would contain all of the
OrgID's related with a single PosID and then another one that shows all
PosID's related to a single OrgID's. Sample:
OrgID PosID
1 A1
1 B1
2 A1
2 C1

Need:
Org Pos
1 A1, B1
2 A1, Ci

Pos Org
A1 1, 2
B1 1
C1 2

I hope you can follow this and give me some help, thanks in advance for I
need this soon!

Chris

 

[Piet Linden]

I have a table with two fields; OrgID and PosID.  The OrgID is the
organization and the PosID is position titles.  I would like to group the
records by OrgID, and list all the PosID found within that OrgID.  I can do
that with a group query no problem; however what I need is to create bothby
OrgID and PosID (2 seperate usages) two fields that would contain all of the
OrgID's related with a single PosID and then another one that shows all
PosID's related to  a single OrgID's.  Sample:
OrgID    PosID
1           A1
1           B1
2           A1
2           C1

Need:
Org        Pos
1            A1, B1
2            A1, Ci

Pos         Org
A1           1, 2
B1            1
C1            2

I hope you can follow this and give me some help, thanks in advance for I
need this soon!

Chris

use fConcatChild available in the modules section of Access web.
www.mvps.org/access