Problem with query output

  • Thread starter Thread starter Dudley
  • Start date Start date
D

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
 
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
Click to expand...

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
 
Back
Top