I don't quite know the proper terms as I've only been using access for the past month or so. I will try to explain what I'm doing in the best way possible.
I have 4 queries, all of which are based off of, in total, 6 tables. In order to make the structure understandable, I'll try to explain...