Combining Data

[Guest]

Searches on this have found similar problems, but as yet I've not been able
to get a resolution to this.

I have a table that lists Changes (each change having a unique Change_ID).

I have another table which lists 'Document amendments' which links to the
Change_ID from each table.

One Change could have many entries within the Document table.

Is it possible to run a query that combines all of the Document_Type fields
that come out for each individual Change_ID within the one query?

e.g. Data currently comes out like:
Change_ID Doc_Type
1 User Rqmnt
1 System Rqmnt
1 Hardware Rqmnt
2 Hardware Rqmnt
2 User Rqmnt

I need this to appear as:
Change_ID Doc_Type
1 User Rqmnt, System Rqmnt, Hardware Rqmnt
2 Hardware Rqmnt, User Rqmnt

Appreciate any help - Thanks, Al. ([email protected])

 

[John Vinson]

I need this to appear as:
Change_ID Doc_Type
1 User Rqmnt, System Rqmnt, Hardware Rqmnt
2 Hardware Rqmnt, User Rqmnt

You need some VBA code to do this. Sample code at

http://www.mvps.org/access/modules/mdl0004.htm

John W. Vinson[MVP]