Delete from Query B where record exists in Query A

[patchesohouli]

Hi,

I have two queries, [Exception Report Employees with Different Frequencies] and [Biweekly]. If employees populate on the Exceptions Report, I want them to be deleted from the Biweekly query. We could use the field “Empl ID” to find matches.

Is there an easy way to do this?

Thanks

 

[jdraw]

answered in the cross post thread
http://www.accessforums.net/showthread.php?t=59588