I have an SQL that I need to turn the following into an
Access Report. I am trying to get it to referance the names (last, first) against the Patinet ID #. The following I was able to get in SQL but can not figure the way to pull it into Access.
select t.test_performed, t.patient_id, t.patient_lastname, t.patient_firstname from test_table as t where exists (select * from patient_table as p where t.test_owner = p.patient_tag and (t.patient_lastname != p.patient_lastname or t.patient_firstname != p.patient_firstname))
The following is what I have so far. However I can figure hoe to write it out to cross reference them...
("n",[TEST_PATIENT_LASTNAME],[PATIENT_PATIENT_LASTNAME])
("n",[TEST_PATIENT_FIRSTNAME],[PATIENT_PATIENT_FIRSTNAME])
("n",[ TEST_PATIENT _ID],[PATIENT_PATIENT_ID])
|