Hello,

I was wondering if it is possible to design a query that can perform an aggragate 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

404 File Not Found on both of those links. I think you want a cross-tab query. However, it's probably best to do what you want in your presentation layer.

Cheers
Ken

Microsoft MVP - Windows Server (IIS)
www.adOpenStatic.com