Search results

Thanks Jack. I will take a look at using a Lookup table. Unfortuinately the example database you suggeted is in Access 2000 and I am using 97 so I could not open it. I will see how the Lookup table goes. Thanks again.

The MS KB sugests a append query for each question in the questionaire, which then appends the results each time a new record is added. But they need to be manually run, from what I can work out. before the data is added to the new table. I will keep plugging away at it.

I have sorted the error message. To saving anyone the time to look at this. I had to enter the column names, separted by commas in the "Column Headings" query properties and it works - YES! So happy now. Just need to sort out the running of the append queires automatically and I will be...

Thanks again Jack. The problem I have experienced is from the example you pointed me to at the Microsoft Website, which suggested creating 10 Append Queries, that append data to a second table. I cannot see how these queries will be run, without me manually running them to append the data. So...

Thanks, I have it working nicely with an addition in the Append queries of the date as I need to produce a report that shows the results for each week or month, etc. This brings me to 2 more questions ( I have searched, but cannot find answers). Firstly, how do I run the cross tab queries...

Thanks Jack. I will work through the forum, now that I know what to search for, and attempt to work it all out. Thank you for your help.

I have just tried this using SELECT new.q1, new.q2, new.q3, new.q4, new.q5, new.q6, new.q7, new.q8, new.q9, new.q10, new.date FROM new WHERE (((new.date) Between #5/1/2003# And #8/31/2003#)); and SELECT test1.q1, Count(test1.q1) AS CountOfq1 FROM test1 GROUP BY test1.q1 HAVING (((test1.q1)=1...

Jack, Thank you for taking the time to help me out, but I am a serious newbie and confused. My table is called "new" and has field names of q1,q2,q3,.......q10 and a date field. Each questionaire entered has 10 questions, hence q1,q2,q3,etc, with 4 possible answers. When a used clicks new...

I have a form that is used to enter data to a table. The form has toggle buttons for a series of questions, with answers of Completely Satisfied, Somewhat Satisfied, etc. and depending what button is "clicked" a value of either 4,3,2,1 is written to the table. I now need to display the number...

Hi, I am a complete access newbie. I need to use the suggestions below with Access 97 but do not understand how I add the code. I have tried clicking the Expression builder, after right clicking on the form, but everything I enter is invalid. Would someone please help with this basic task -...