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

Hello,

Does you query need to display also tests from entirely missed visits? This would be useful if the trial has completed, and vice versa.

Dimitar

Yes, I would need to know that as well. Any suggestions would be appreciated.

Thanks,

Bob