VBA comparing fields from seperate tables

[Yakisoba]

I am trying to build a form in access that will (at the click of a button) compare each field from one table to another (approx 25 fields). Then print the result to another table.

Basically the form is checking a quiz (table) against an answer (table) and storing the test results for each field in another table.

Currently I have:
A table that holds the quiz answers (entered through a form)

A table that holds the quiz answers as entered by the "student". (these results are imported from an excel file)

A table that holds the quiz result. (if the answer is correct a "1" is displayed, if wrong "0" is displayed) - currently this is empty

What would be the best way to compare the data from the each field in each table?

Should the data from each field be stored in a variable before comparison. or should I run a query each time and compare the result.

Any suggestions would be appreciated.


Thanks


Yak


Let me know if this is in the right forum.