Report with each field showing data from all records

  • Thread starter Thread starter ADavis
  • Start date Start date
A

ADavis

Hi there,

I want to be able to create a report that will take each field (any
data type) and a place all the data from that field into a space just
beneath the field name on the report. I DON"T want a tabular report
with lots of columns. I could create a report using one field at a
time but I want each field's worth of data to follow in sequence. Man,
am I making any sense? An example:

Table
LName FName Notes
Armstrong Lance This is a very fast rider.
Ullrich Jan This one does drugs.
Bettini Paolo This one is world champion.

Report
LName
Armstrong
Ullrich
Bettini
FName
Lance
Jan
Paolo
Notes
This is a very fast rider.
This one does drugs.
This one is world champion.

Notice each field name is listed then ALL the data from the table or
underlying query for that field.

I also want to know how to reference a field's description in a report.
Can anyone help with that?

Thanks so much for the help.
ADavis
 
I am sorry for posting to the wrong group. This post is now found in
ms.public.access.reports. I still need an answer!

Thanks.
 
Back
Top