Having a hard time putting a title on this one. This is odd. I seem to never have come across this before. Also possible that I am going senile and missing something obvious. Trying to figure out how to do this in a query. Example below.
Let's say I have a table that looks something like this:
Order.........Item.........Received
123...............A....................Y
123...............B....................Y
123...............C....................N
223...............A....................Y
223...............B....................Y
223...............C....................Y
And in the example above, let's say there are many more records, orders/items/received indicator.
In a query - what is the best way to show all order numbers that are received, completely and all orders that are not completely received?
I can do it but, not liking the hoops I jumping through. Seems like there ought be a simple way to query for this.
Thanks!
Let's say I have a table that looks something like this:
Order.........Item.........Received
123...............A....................Y
123...............B....................Y
123...............C....................N
223...............A....................Y
223...............B....................Y
223...............C....................Y
And in the example above, let's say there are many more records, orders/items/received indicator.
In a query - what is the best way to show all order numbers that are received, completely and all orders that are not completely received?
I can do it but, not liking the hoops I jumping through. Seems like there ought be a simple way to query for this.
Thanks!