Query with several groups

[jvlajcic]

Ok, so I have a number of servers in a database that I want to sort by the departments that use them. There is a Business Function field (contains things like "Finance" and "Marketing" and a Business Service field (contains things like "Vendor Management" and "CRM"). The servers come in a number of OS flavors (Windows, Linux, etc.) and I want to create a master query that has servers grouped by Business Function and Business Service and then gives me a count of each server by each type of OS.



I've created a number of sub-queries for each OS: the queries group by business function and business service and then have WHERE statements for the OS values ("*Windows*", etc.) and then a count for the OS field. There is one query for each OS and then one master query that pulls together all the counts for OS's. It looks ok but I keep getting way more values then I should have. I'm not sure what the problem is, can anyone help?

I'd like to put the master query into a pivot table and get totals for all the Business Functions and Business Services.

[orange]

Post your SQL and other relevant factors.