I am a complete novice and would appreciate some help. What I am attempting feels like it should be easy but I cannot find an answer.

On a contact record I want to create a questionnaire which we would complete by ticking yes/no boxes. The respective answer will generate a standard paragraph of text which would then be inserted into a report template for presentation to a client.

e.g. we may ask :

do you have a credit procedures manual? Yes No

If they select yes a sentence such as ' we recommend you create one' will be added to a standard report template.

Is Access the best vehicle for this? If so, how can I do it?

Many thanks in advance for suggestions.

Steve

Hi, Steve,

Welcome aboard.

What you want to do can be done in Access.

Your question however was, "Is Access the best vehicle for this?" and the answer to that questions depends on if this database is to be used outside your organization. If the database is to be used only internally then Access would do the trick.

As for your second question, "how can I do it?"; You would need a couple of new tables. One to store the answers to the questions and one to store the statements that are to be used for response to the answers.

I will assume that the Contact record you are viewing is being viewed through a form. You will need a form with the new table to store the anwers as its record source. This form will have the questions with check boxes. You will need a command button on your original Contact form to open the new form.

Once the answers are acquired you will then need a report to display the results.

I know this is very general, but at least that should get you started.

HTH

Thanks for taking the time to reply.

I will give this a whirl, hopefully it will be within my capabilities!

Cheers
Steve