Query to compare field

[patrickcre8]

Date:

Date...............Item...................Status
200601............A........................OK
200602............A........................Not OK
200601............B.......................OK
200602............B........................OK
200602............C........................OK

I want to construct a query which can only show result as follows:
200601............A........................OK
200602............A........................Not OK
200602............C........................OK
..by comparing the status change

Any brilliant idea? (preferably not using dlookup)

 

[TanisAgain]

I don't understand. What is the difference between 200601 A OK and 200601 B OK. I see that item B is missing, but what differentiates A from B in this instance? Also, I hope that you dates are not in that format!