DEVELOPING QUERIES TO ADD UP MULTIPLE QUESTIONS WITH YES/NO ANSWER

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I need some help. I have put together table and a form. It is more like a survey of about 12 questions. Various types of question which require yes/no or make a choice or selecting multiple choices.

The problem I am having is designing a query and then a report to show:

For Example:

How many male?
How many active duty?
How many live on base less than 6 months?

Total of all the above ????

Please Help
 
This can't be answered without you providing your table structure. If your
tables are properly normalized, you might want to see how this is done in At
Your Survey found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

--
Duane Hookom
MS Access MVP


Joe Richardson said:
Hello,

I need some help. I have put together table and a form. It is more like
Click to expand...
a survey of about 12 questions. Various types of question which require
yes/no or make a choice or selecting multiple choices.
 
Back
Top