Hello all
I’m trying to do something as simply as possible and was just wondering how I would go about comparing information from the different tables in my database using just access sql and no vba.
Example scenario:-
I have four tables within my database.
The first table records all info about patients. In this table, many to many relationships are not broken up, so there is duplicated information. An example of what the table may conatin is PatientID, name, surname, date of birth, and symptoms. A patient can have more than one symptom and a symptom which is from a defined list can relate to more than one patient....All this information has been recorded by person A. Hope this is making sense so far!
I then have three other tables in my database whereby one table records patient info, a second for patient_symptoms and a third recording the list of symptoms, the information has been recorded by person B.
The information about the patients is exactly the same apart from the symptoms. I would like to compare the symptoms recorded by person a and b - a list of where there is exact matches, where there may be some similar, and where it is completely different.
I have simplified this as much as possible using the above example....what is the best way to do the comparison???...
Thanks in advance Sub.
I’m trying to do something as simply as possible and was just wondering how I would go about comparing information from the different tables in my database using just access sql and no vba.
Example scenario:-
I have four tables within my database.
The first table records all info about patients. In this table, many to many relationships are not broken up, so there is duplicated information. An example of what the table may conatin is PatientID, name, surname, date of birth, and symptoms. A patient can have more than one symptom and a symptom which is from a defined list can relate to more than one patient....All this information has been recorded by person A. Hope this is making sense so far!
I then have three other tables in my database whereby one table records patient info, a second for patient_symptoms and a third recording the list of symptoms, the information has been recorded by person B.
The information about the patients is exactly the same apart from the symptoms. I would like to compare the symptoms recorded by person a and b - a list of where there is exact matches, where there may be some similar, and where it is completely different.
I have simplified this as much as possible using the above example....what is the best way to do the comparison???...
Thanks in advance Sub.
