I am confused on where to start on this project.
I have 3 queries that are doing counts for different things. They count High's Medium's and Low's. I would like to build a query that takes the totals of all three queries that counts different things and combine them into one query that Adds all the High's together, all Medium’s together, and all the Low's together. I need it to build a bar chart from the new query. I am sure this is simple but I am not sure where to start.
Example:
Query 1 Query 2 Query 3
High 10 High 5 High 3
Medium 5 Medium 30 Medium 15
Low 20 Low 15 Low 5
New Query that adds all the above queries together:
High 18
Medium 50
Low 40
Thanks,
Darkhat01
I have 3 queries that are doing counts for different things. They count High's Medium's and Low's. I would like to build a query that takes the totals of all three queries that counts different things and combine them into one query that Adds all the High's together, all Medium’s together, and all the Low's together. I need it to build a bar chart from the new query. I am sure this is simple but I am not sure where to start.
Example:
Query 1 Query 2 Query 3
High 10 High 5 High 3
Medium 5 Medium 30 Medium 15
Low 20 Low 15 Low 5
New Query that adds all the above queries together:
High 18
Medium 50
Low 40
Thanks,
Darkhat01