Lookup Table into Report

[pattyjean]

I have 150 fields on a table organized by
Course. Section. ICS. 1.1.a ,1.1.b., 1.1.c, 1.1.d, 2.1.a ,2.1.b etc.


I need to label each of the 1.1.a with text example:
1.1.a. Are you teaching math
1.1.b. Are you learning math
1.1.c. Are you enrolled in this course

In the fields it would by Y/N answer
and based on the results I want to make a report with the results but I don't know how to add the labels in? How can I organize this

 

[GingerR]

Sounds like you first need to Normalize your data. See the links in my signature for help, then check back.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[dhookom]

Your table structure isn't normalized. You might want to search on "Hookom At Your Survey" to find a solution that allows for better reporting flexibility.

Minimally you will need a table of question labels.

Duane
Hook'D on Access
MS Access MVP

 

[pattyjean]

Looking at the database I might be able to figure a different approach to the project. Thank you to both of you. Yes I did have the questions in a different table.