Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Group quesiton for survey report

Status
Not open for further replies.

mdc88

Programmer
Jul 31, 2002
1
US
Have a report that references several tables from a database for a survey. The problem I'm running into is this:

The questions table is:
question_no
question

The questions options table is:
question_no
option_no
option_desc

The cust responses are:
question_no
option_chosen (related to the option_no)
response_text

The quesitons were set up like:
1. question
1.1 option
1.2 option etc...

or
2. question
response text

I'm trying to set this up with two subreports so that if I group I don't lose one set of data vs. the other. I've been back and forth here and am losing track of the big picture I think. Any help in direction would be appreciated.

Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top