list values horizontally

[pbuethe]

I have:

tblToEnterDates: with IDNbr (PK), RptDate
tblToEnterLines: PK is IDNbr & LineNbr, has some other fields
tblToEnterSamples: PK is IDNbr & LineNbr & SampleNbr, also field Charts.

Each table has a one-to-many relationship to the next.

On the report I show the date from tblToEnterDates in the header, with the corresponding records from tblToEnterLines in the detail. Within the lines I want to show the corresponding SampleNbrs, listed horizontally, e.g. 0012, 0102, 0107, 0208 instead of
0012
0102
0107
0208

I appreciate your help.

 

[samehkh]

The only solution I can think of is make a table for the report, structure the table the way you want the report to be, purge it before you open the report and use an a ppend query to fill it up with the data for each specific instance of the report.

 

[Rich]

Article ID: Q141624

 

[pbuethe]

Thanks Rich, this looks like exactly what I am looking for. I will have to study it.

 

[pbuethe]

It Worked! Thanks Rich.

 

[samehkh]

I tried it too.
Very nice.