Followup to Database results
June 7, 2006 12:00 AM
I finally found the problem. It was in the Access file. From the access file I downloaded, the data type for TrueFalse and MulitpleChoice were set as Numbers. By changing the data type to Text and Indexed to: Yes (Duplicates OK), I was able to get the correct values.For example, in a 5 question test, where 3 are Multiple Choice and 2 True and False, once all the questions were answered correctly, then under Multiple Choice I got 3/3 and under TrueFalse I got 2/2. Hence if I got only 2 multiple choice questions correct I would get a value of 2/3 and so on.If anyone else has this issue I hope this helps.Regards,
Discussions have been disabled for this post