survey

G

Guest

I have been wrestling with this one for a while and can't crack it. Here goes:

I want to build a survey form which will drop results into a table. The
results will be based on facility inspections consisting of about twenty
questions for each inspection. I want to be able to generate a report based
on the inspections which will show the inspection results for a specific
room, building and inspection date. Here are the tables I have:

Questions: with fields for Question #, Question, Deficiency, Corrective
action, and Rule Citation

Survey Results: with fields for Building(lookup), Room(lookup), Inspection
Date, Question #, and Inspection Result(lookup).

I have no problems using a lookup field for building and room, but I am
having trouble using a sub-form for the survey data entry.

How do I make an inspection form which will bring up all of the survey
questions so that the building, room and inspection date only need to be
entered once for each inspection?

Any assistance will be greatly appreciated.
Mark
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Distinct Count in Crosstab 1
Query Help 4
Record county by status 1
Inspection Database Design Help Please 0
DMax expression 2
Conditional command button 6
GroupBy Query Problem 3
Query by Form 10

Top