Display records horizontal in report footer 1

[Oliver2003]

Is it possible to display records horizontal in report footer.

I have a table which is used as a key to numbers on the report and I would like to display this horizontally across the bottom of the report.

The table is TblKey and the fields are KeyNo and KeyName, I would like it to display:

KeyNo1=KeyName1 KeyNo2=KeyName2 KeyNo3=KeyName3 etc

Is this possible?
Cheers

 

[straybullet]

Probably NOT what you are looking for but:
You could just type that info into the Report Footer

 

[dhookom]

Create a subreport that has multiple columns. Make sure the columns are set to display across then down.

Duane
MS Access MVP

 

[Oliver2003]

Thanks for the replies,

how do you set the columns to display across then down??

Cheers

 

[Oliver2003]

Figured it out, - its on the page set-up
Been wondering how to do this for ages
Thanks