Database question - is this possible?

[beer]

OK -

I got assigned a project for my Student Cogress. Basically, as a fund raiser, we handed out "compatability tests" to all 1700 students at our school and we got them all back. We entered them into an Access database online.

There are 30 multiple-choice questions, so the database has some 34 fields:

TestID, name, age, sex, 30 questions.

Is there a way to run a report on the database and have it look for which records have the most characters in common, and match them together? Is there an algorithm for it?

Please.

 

[billandopus]

Try the various newsgroups on UseNet .... deja.com

You'll get an answer there for sure.

 

[KidViciou$]

can yo ureally do that in access? i know for a fact you can do that in oracle using PL/SQL