How can I have a query display horizontal one 1 line

[colezpapa3]

I havea query with 3 fields USER, APPL_ID, and USER_ID.
THe query lists them vertically....

USER APPL_ID USER_ID
------- ------- -------
JSWIFT GRPING CCAEER8
KTHOMAS GRPING CCAEER9
KTHOMAS GRPING CCAEER7

How can I display the USER_ID horizontally like this...
KTHOMAS GRPING CCAEER9 CCAEER7

I tried a crosstab but get too many headers, or no property found.

 

[Remou]

If you have too many records for a crosstab, it may be best to use Excel and transpose.

 

[dhookom]

IF you are getting "too many headers", this suggests you have more than 200+ USER_ID values. If this is the case then you might need to create multiple queries that limit the USER_IDs.

Duane
Hook'D on Access
MS Access MVP

 

[PHV]

Have a look here:
faq701-4233

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886