Duplicate Records on same row

[jameshopper]

Hi,
wondered if you may be able to help. I'm looking to run a report on a table that i currently have set up. When i run any kind of report, each line on the report is dedicated to one record. What i'd like to do is have numerous records on one line. for example

currenlty, the report comes out as
rep id Header 1 Header 2 Header 3
1234 abc
1234 zzz
1234 xyz

(I know i can group the rep id's, but this is just to show the example )

what i'd like if possible is for the report to come out as

rep id Header 1 Header 2 Header 3
1234 abc zzz xyz

is this an easy thing to set up?

 

[lupins46]

Have you tried the Crosstab query wizard?

 

[jameshopper]

thanks lupins,
does that work if the data is all from the same table

 

[ideafixer]

Yes.. crosstabs can be used for one table.