aggregate function on text

[kenche0820]

Hello,

I was wondering if it is possible to design a query that can perform an aggregate function on text (compressing records into a comma-delimited list).

I currently have a database with tables for lighting, sound, props, etc. (see

http://www.perfec.com/drama/ERdiagram.gif)

What I'd like to do is have a query that summarizes the lighting cues, sound cues, props, etc. that exist for each scene.
(see

http://www.perfec.com/drama/qryPromptBook.gif)

Does anyone know if that is possible?

Thanks very much for your time.

Kenneth Cheung

 

[JonFer]

Please post what you want the output to look like and provide a few records from the tables.

 

[dhookom]

As JonFer suggests, typing or pasting a few records and the desired output would really help. If I understand correctly, you can concatenate multiple child records using a generic function. There is a sample of this function and how to use it at

http://www.rogersaccesslibrary.com/OtherLibraries.asp.

Look for Generic Function to Concatenate...

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[kenche0820]

That generic function was exactly what I needed. Thanks very much for your prompt reply and valuable advice!