I need help with a query.
My query generates a list of the opened orders that shows the tech where to find the item/serial number requested by the client, the thing is that 1 serial number can be found in multiple locations.
In the table below, Serial number ABC12378944 is located in 4 locations, the serial number from Rack MAIN-1-3-5 Loc # in the Dept MAIN was not collected and is marked as No, but the tech found the serial number in Rack Main-1-2-1 in the Dept MAIN and marked it as collected “Yes” - Third image
My query will stop showing the entries marked as Yes or No. but will continue to show the rest of the entries, as you can see on the screenshot below which now shows only 2 entries. I want the query to stop showing the serial number entries from the same account if one of the serial numbers from the same account is marked as Yes.
The first image is the Query, second is the query result.
Thanks in advance.