Crystal report needed to show immunizations not in medical record
Posted on 2014-09-22
I am using a SQL 2008 database. I need to write a Crystal report to show what patients do not have certain immunizations. All the immunizations are recorded in one table called order. The field I am querying lists the code associated with the immunization for example (90658, 90672,90656,90669, 90772) I have tried a selection statement such as "not acctcode like ["90670",90732"] This returns a list of patients and excludes those records form my list. However it does not check to see if those items are in the table. I do no think my logic is correct. Can someone provide some other ways to exclude those patients with those acctcodes.