Creating a questionnaire type form??!

[Maxine1010]

I'm trying to create an audit tool that can be used for different departments. There are approx 50 questions which will be applicable and will all be answered via yes/ no answers and a comment text box. The problem I have is that ideally I would like to create a new table each time the database is used (i. e. for each department) displaying all of the questions and relevant answer. Does anyone know if this is possible or how I can get around this?

Thanks

 

[Pat Hartman]

Having a separate table for each department is not an ideal solution. You should store all the data in a single table and add a department column so that you can separate it as necessary via queries.

 

[Maxine1010]

Pat,

I would prefer to have just one table with an identifier used for each different department. I originally tried to create a department ID column but the table appears not to work. Also all of the questions are already entered in to a table, but I don't know how to display these on a form so that people can enter the answers which will ultimately go into the table, and reports run.

Can you help with this?