How do i delete multiple records in a union query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to combine two queries and only post the records that are not in
one of the queries. For example, i am creating a queries in access that show
what products pass an inspection and fail an inspection. The products are
considered "failing" if this are not reworked. This will tell the employees
to try to fix the problems. So basically...i want to take the failing query
and subtract the records from the items in the passed query.
 
"Need help with multiple queries" <Need help with multiple
(e-mail address removed)> wrote in message
I am trying to combine two queries and only post the records that are not in
one of the queries. For example, i am creating a queries in access that show
what products pass an inspection and fail an inspection. The products are
considered "failing" if this are not reworked. This will tell the employees
to try to fix the problems. So basically...i want to take the failing query
and subtract the records from the items in the passed query.
Click to expand...

SELECT * FROM qryPassed P LEFT JOIN qryFailing F ON P.SomeKey = F.SomeKey
WHERE F.SomeKey IS NULL
 
Back
Top