D
DDBeards
Please forgive for posting this again, but I thought maybe I had posted it
under the wrong area......
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
under the wrong area......
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