Search results

Many thanks Pat, I have had a look at your version of my database, and all works perfectly. I started finishing off the forms but progress has be interrupted by illness, hence my delay in replying to your message. Thank you once again for your time and for helping me solve these problems! Emma

Hi Reclusive Monkey and Pat I am so close and yet so far!! I have sorted out my structure for my questionnaire database and am happy that I will be able to query it as required. What I am now having problems with is my form for the data entry, which is based on the append query, as predicted by...

Hello Reclusive Monkey Thank you so much for your help - I am so grateful to you and Pat for your comments and time in helping me. I am about to start designing my form tonight so I have something to show the committee who are undertaking the survey tomorrow. I am finding that over the last...

Thanks for your reply Pat. I understand what you’re saying and was trying not to come to the same conclusion that you have given me!! Partly because I am looking for the simplest structure I can come up in a short amount of time. I have created another test database but though I am confident I...

Hi reclusive monkey No, neither US or working late - I am doing someone a favour with this database and they need the questionnair data entry forms on Tuesday - the querying of the database will not be for a while yet. However I wanted to check I could get some sensible results out before...

I have posted a copy of my database for you to look at, I hope it makes more sense than my original message. The query results I want to get are totals for each option of each question. I hope seeing the database makes it all a bit clearer. I would just add, this questionnaire is one I have...

I have a very simple database for recording data collected from a questionnaire. The database comprises of table1: QUESTIONNAIRE fields: QUESTIONNAIRE ID QUEST_1 ........ up to QUEST_75 table2: VALUE (1 to 6) ANSWER (strongly agree, agree etc) All of the 75...