Query on DB that is not mine

[Guest]

I am trying to combine two records into one.

For example, there is a query that returns the following fields:

PatentInventorID Patent0Code PatentMasterID
1 Smith 1
2 Jones 1
3 Jacob 2
4 Smith 3
5 Jones 3
6 Jacob 3
7 Roberts 4
8 Davis 4
9 Smith 4


Instead of having PatentInventorID for EACH inventor, this database has
PatentInventorID for each PatentMasterID. I want to run a query that returns

1st Record
PatentMasterID: 1
PatentInventorID: 1, 2

2nd Record
PatentMasterID: 3
PatentInventorID: 4, 5, 6

3rd Record
PatentMasterID: 4
PatentInventorID: 7, 8, 9

Thanks for any help.

 

[Douglas J Steele]

It can't be done strictly using SQL: you'll also require some VBA.

See http://www.mvps.org/access/modules/mdl0008.htm at "The Access Web" for
one approach.

 

[Guest]

Wow! Don't expect to hear back from me today. lol. It might take me
awhile. It will be a challenge but I am up for it. )

Thanks.