Hello,

Can you help with the following situation?

I have a large table which contains lab results for patients enrolled in a clinical trial. There are certain lab tests which are required for each trial visit.

I need a query which returns a listing of patients which have missing tests, the visit numbers which have missed tests, and the name of the missing test(s) for that visit.

The list of required tests is stored in a second table. So one example of a returned row would be as follows.

Patient Visit Number Test Missed
003 001 Albumin

Does anyone know of a query which can accomplish this?

Thanks,

Bob