Hi guys, I am working with MS Access and I am trying to build a query that is able to look at multiple codes, and their results, and then filter the entire group (or not).
So basically it looks like this. (imagine this is two columns in access)
Code:
Code Result
253
253 5
253
62363
362366 4
7554753 8
7554753 8
7554753 8
7554753
7554753 8
53263
3632
3632
3632
3632
25235 2
235636
34234
What I am trying to do, is to filter out both any single "code" that has a blank, or any group of codes that **all** have blanks.
So for example the end result would be.
Code:
Code Result
253
253 5
253
362366 4
7554753 8
7554753 8
7554753 8
7554753
7554753 8
25235 2
Now I have no problem doing this for single lines or what not, but I am really having trouble wrapping my head around doing entire groups. Does anyone have any ideas or suggestions?
Thanks.
If I am not too clear, please ask any questions.
Just to clarify, I want to remove all "groups" of "code" that are blank in result.So if a number in "code" is blank in result, it would filter it out.
The thing is though, I want this to apply to the entire groups. So if an entire group (say all the 253s) are blank, than it filters them all out, but if even a single one of them has a number. It would keep it.
Thank you.