Query Help

[idire]

solved elsewhere thanks

[Fumigator]

You need to normalize your database sir! You should not have separate columns A1, A2, A3, etc... You should have a separate table that stores the answers.

And I'm sure you don't want to hard-code the answer key... you'll need another table that stores the answer key that you can use to compare the pupil's answers.

[If I Were A Boy]

The Tables in your database should be normalized at least for 3N to get effective and optimal results.

[guelphdad]

Please do not post to a public forum and then remove your post. Leave the post as is and post the solution.