I have a table with the following fields
LabID PatientNo Testdate Testresult
On different dates the test may be repeated
The test result may be either Sensitive,Resistant or null
I have grouped all patients using find duplicates(PatientNo)
I wanted to build a query or VBA to find out the patients who on a testdate was sensitive but became resistant on a latter date(not vice versa)
Thanks in advance for any help
LabID PatientNo Testdate Testresult
On different dates the test may be repeated
The test result may be either Sensitive,Resistant or null
I have grouped all patients using find duplicates(PatientNo)
I wanted to build a query or VBA to find out the patients who on a testdate was sensitive but became resistant on a latter date(not vice versa)
Thanks in advance for any help