Many Thanks

Lakh

SELECT dbo_pod_surgery.name, dbo_pod_surgery.PHC_ID, dbo_pod_surgery.[Contact Date], dbo_pod_surgery.[Referral Date], dbo_pod_surgery.activity__2,

FROM dbo_pod_surgery

WHERE (((dbo_pod_surgery.PHC_ID)="22/15729" Or (dbo_pod_surgery.PHC_ID)="23/13278"));

Thanks

Lakh

namePHC_ID Contact DateReferral Dateactivity__2

John22/15729 14-Mar-0602-Feb-06SS70

John22/15729 24-Jul-0602-Feb-06SS78

John22/15729 21-Aug-0602-Feb-06AS0630

John22/15729 25-Aug-0602-Feb-06SS71

John22/15729 01-Sep-0602-Feb-06SS76

John22/15729...

I have try to used "not like" it only void the 3rd line but i need to void everything for John.

lakh

From my report If this code "AS0630" tell me the person had they money back. I am only looking for people who have not receive they money back.

Lakh

Hi Madhivanan,

This is my query see below.

Please can you add the missing part for me. i am having erorro message.

SELECT *

FROM dbo_pod_surgery

WHERE phc_id="22/15729";

Lakh

Thanks

Lakh

If any invoices matching to code AS0630 that showing me the invoices are paid and take it off my list.