Hi , I am new to access, but I hope that I can learn from the experts on the forum here and videos on MS Access online. Hopefully, work will pay for a course, but I have a challenge, I have two tables that have a common key. It is called LOINC Code in the OLIS table and LOINC/pCLOCD Code in the pCLOCD table. I want use the LOINC code from the OLIS table to see if there are updates in the pCLOCD table. I would like to be able to produce a report that shows the code and what the difference is from the OLIS table. The tricky part is that a single code may have more than more difference, so i need it to look up to 7 fields. I have tried 'find unmatched', but it only works for one field and I need to look at multiple fields for each code. Is there a single SQL that can accomplise this task?
OLIS table pCLOCD Table
LOINC CODE..........................LOINC/pCLOCD Code
LOINC Component Name........ LN COMPONENT
LOINC Property.................... LN PROPERTY
LOINC Time ........................ LN TIME
LOINC System .................... LN SYSTEM
LOINC Scale........................ LN SCALE
LOINC Method....................... LN METHOD
Result Category..................... LN CLASS