A
Adam
Hello,
I have set up a query to pull the following data out of a table:
MaterialID
Material Name
Miscellaneous
Tonnage
Waste Class
In this instance, Waste Class can be 1 of 2 options. I have residential and
commercial as my inputs. I am trying to set up a final query that will show
the total tonnage of each material type but break it into res & com and then
show a total. I intially set the final query up as a link between two basic
queries: Residential Summation & Commercial Summation. The problem that I'm
running into is that there are more records on the Residential side (waste
categories) and when I join the two queries, some of the waste types don't
sum correctly. I have the join set up to show all the residential waste
types and show those commercial types that show up. In the past I've been
able to make a similar set of queries work by adding in zero entries to match
both sides. I was wondering if there was an easier way to do this?
Hope this is clear!
Thanks,
Adam
I have set up a query to pull the following data out of a table:
MaterialID
Material Name
Miscellaneous
Tonnage
Waste Class
In this instance, Waste Class can be 1 of 2 options. I have residential and
commercial as my inputs. I am trying to set up a final query that will show
the total tonnage of each material type but break it into res & com and then
show a total. I intially set the final query up as a link between two basic
queries: Residential Summation & Commercial Summation. The problem that I'm
running into is that there are more records on the Residential side (waste
categories) and when I join the two queries, some of the waste types don't
sum correctly. I have the join set up to show all the residential waste
types and show those commercial types that show up. In the past I've been
able to make a similar set of queries work by adding in zero entries to match
both sides. I was wondering if there was an easier way to do this?
Hope this is clear!
Thanks,
Adam