Im enclosing the database to give a better understanding of what I'm trying to do. I have four main forms that have subforms on them. What I want the queris to display is all the info for the main form and also all the choices that were selected in the subform. Also will be making queries based on date, unit, and area. And also im going to make reports from those queries.
This is a example of what im trying to do:
Date Unit Area Question 1 Answer 1 Comment 1
Question 2 Answer 2 Comment 2
Just how would I do this? I'm using 97
This is a example of what im trying to do:
Date Unit Area Question 1 Answer 1 Comment 1
Question 2 Answer 2 Comment 2
Just how would I do this? I'm using 97