i am doing the code via vb.. so i would have to do it by sql..
Geez ... Wrong forum don't you think?????
But, here's how you set up an unmatched query:
SELECT [Work Orders II].WorkOrderNumber
FROM [Work Orders II] LEFT JOIN [WO Billing] ON [Work Orders II].WorkOrderNumber = [WO Billing].WorkOrderNumber
WHERE ((([WO Billing].WorkOrderNumber) Is Null));
im building my app around an access database so i thought this may be the forum but hey.... got it to work
Thanks alot matey
UPDATE PATIENT_DETAILS LEFT JOIN EXTRA_NOTES ON PATIENT_DETAILS.PATIENT_ID = EXTRA_NOTES.PATIENT_ID SET EXTRA_NOTES.PATIENT_ID = [patient_details].[patient_id]
WHERE (((EXTRA_NOTES.PATIENT_ID) Is Null));