Problem with query output

[Dudley]

I am trying to set up a query to output to Word with the format:

Company=XYZ
Director=Joe Smith
Director=Peter Jones
Secretary=David Smith

However my Access 2000 select query comes out as 2 records

Company=XYZ
Director=Joe Smith
Secretary=David Smith

Company=XYZ
Director=Peter Jones
Secretary=David Smith

How do I get the output I need?

Thanks for any help.
Dudley

 

[Piet Linden]

I am trying to set up a query to output to Word with the format:

Company=XYZ
Director=Joe Smith
Director=Peter Jones
Secretary=David Smith

However my Access 2000 select query comes out as 2 records

Company=XYZ
Director=Joe Smith
Secretary=David Smith

Company=XYZ
Director=Peter Jones
Secretary=David Smith

How do I get the output I need?

Thanks for any help.
Dudley

Can't be done with pure SQL... (well, at least not my me!) What you
are describing is collapsing a one-to-many relationship to the "one"
side. You could use something like the "fConcatChild" function that
is here... http://www.mvps.org/access/modules/mdl0004.htm