I am using MS Access 2000. A table contains candidate (personnel) names and detailed data. These individuals are called in to take MS Office skill tests plus others. Their scores are entered in a form to the table. I would like to create a query and report that lists only those personnel that have taken any tests and their resulting scores. I don't know too much about the "if" in queries, would this be applicable here? Here is an example from the form:
Candidate test scores & training
TestDate: (input) 11/4/2009 mm/dd/yy
Test A: ___score___ Test C: ___score__
Test B: ___score___ etc.
Overall: ___score___
I thank those in advance for any advice.
hardware
prices 
