Hey folks - I've done several searches to try to answer my question here and on google, but can't seem to find what I'm after. At work, I frequently have need to interview people from a set of questions and then summarize the interview in a narrative. The list of questions is usually about the same but varies from person to person depending on the circumstances. What I want to try to do is create a list of all possible questions with a box to answer them, and when done create a narrative by clicking a button or something. For instance, if the questions were only a) What is your name and b) What is your address, then I would like to enter that information on the question sheet and then be able to click a button that produces a narrative that I can then paste into a word doc, email, etc. For example, I would like to see

1. What is your name? John Smith


2. What is your address? 123 Main Street

be changed into

I interviewed John Smith who resides at 123 Main Street.

This is a simplistic example, and the interviews I conduct are more involved. It would also be nice if, on the list of questions, there is no supplied answer because the question does not apply to the interviewee then the subsequent narrative would not include the related sentence.

Can I somehow use microsoft office to accomplish this? It's something I'd like to play around with and see if I can make it work. If someone could point me in the right direction I would really appreciate it, as I have no idea where to start. Usually if I can find reference material for what I want to do I can figure it out but as mentioned I have no idea where to start with this one.

Thanks, Bill

Hi Bill,

Word is probably not the best application for this. An Access database, with the appropriate fields, from which you could produce a report is more likely to suit your requirements. For that, I'd suggest you contact the Access Forum: http://www.accessforums.net/

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]