Guessing on your structure here but inner join the patient table to the diagnosis table and the outer join the diagnosis table to the blood work table.
In the select expert make diagnosis=Diabetes (or ICD code if you use it)
In the report group on patient ID
Add an extra group header (B)
sort descending on blood work date
place the desired result fields for display on the group header B
these should be from the most recent blood work for that patient
They will be NULL if the patient has no blood work reported
Edited by DBlank - 08 Apr 2010 at 8:26am
IP Logged
