survey

[Frank]

I have a mutipage tab form listing residents details. One
of the page tabs content is intended to gather
information about a residents interests. i.e.
education,heath, childcare etc

I tried to do this by adding combo boxes that look up an
interests table for items to be selected which works fine
but....I need to be able to create a report based on the
selctions. ie who is interested in health issues or
childcare?

Any ideas would be appreciated.

 

[Ed Robichaud]

You would create a select query based on your resident info table. Set the
criteria to find any specific interest and use this query as the record
source of your report. Or you could also create a group on your report
based on the interest field and it will list the resident names in the
detail section for each unique interest.
-Ed

 

[Jim/Chris]

Here is a good website with a sample survey database.
Perhaps you can get some ideas.
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'

Jim