Include Field Description in the Report

[basement131]

i have searched the forums with no success on this topic.
i have a table which was based on a survey
the the fields are as follows
Name
city
question1
question2
question3
and so on till question50.
Now within each field under the design view i have included the 'actual question' (i.e - questions1 - how many employees work in your department?) in the "Field Description".
now here is what i would like to do.
i would like to print out a report (columnar report) which lists the field name "question1" then beside to the right "the actual question" and then beside it to the right "the data".
i am not too familiar with using reports but for now i need to know how to get the description of the field onto the report.

any help is much appreciated.

 

[PPJOSEPH]

Hi Basement131:
I have an idea and honestly I would do it if its my db. Its kind of crude but straight forward.
I would use the trim function for the data field.

How to:
open the report in design view
From the toolbox, drag a textbox close the data field.
in the textbox and type in

=Trim("Question 1 - How many employees work in your department? " & [question1])

I assume if you that your data field name is question1

Do not delete the original data field instead make it invisibile by setting visible property to NO under properties

Finally, resize the textbox to fix your trim stmt.

Paul

 

[basement131]

thank you & You are correct and indeet that is a crude way of doing it.

however, i would like to have it so that i can draw from the 'description itself" as apposed to typing it out myself.