Query format problem

D

Dudley

I am trying to create a query in order to export to Word in the format:

COMPANY:XYZ
DIRECTOR:JOE SMITH
DIRECTOR:pETER JONES
SECRETARY:DAVID WILLIAMS

However, the Access 2000 select query comes out as two records:


COMPANY:XYZ
DIRECTOR:JOE SMITH
SECRETARY:DAVID WILLIAMS


COMPANY:XYZ
DIRECTOR:pETER JONES
SECRETARY:DAVID WILLIAMS

How do I produce the format I need?

Thanks for any help.
Dudley
 
P

PieterLinden via AccessMonster.com

Dudley said:
I am trying to create a query in order to export to Word in the format:

COMPANY:XYZ
DIRECTOR:JOE SMITH
DIRECTOR:pETER JONES
SECRETARY:DAVID WILLIAMS

However, the Access 2000 select query comes out as two records:

COMPANY:XYZ
DIRECTOR:JOE SMITH
SECRETARY:DAVID WILLIAMS

COMPANY:XYZ
DIRECTOR:pETER JONES
SECRETARY:DAVID WILLIAMS

How do I produce the format I need?

Thanks for any help.
Dudley
Click to expand...

Use Allen Browne's solution...
see this thread:
http://www.accessmonster.com/Uwe/Th...ies/53891/Concat-Related-Query-Design-Problem
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with query output 1
Subquery help 2
how do I create supervisor hierarchy with the access table 2
Auto Fill Word Documents 4
Delete all data after a symbol in a field 0
Help with INDIRECT 7
Select with Conditions 2
Need help with query results 8

Top