Creating Report For Total Users Per Job

So I had a report I needed to create and needed to get the total users per job for a system that I was not (and still am not) very familiar with. I asked the developer for that system for the code and was told it was no easy task. He sent me a query that didn't look anything like a user count. I told him I needed something to get all the users for each and every job in order to put it in the report I was building for one of the clients. I was told that wouldn't really work. I looked at his code as it worked on a per job basis.

The following is an example of the "logic" used to get the user count per job in asp.net:
TRUNCATE TABLE1
INSERT username INTO TABLE1 FROM QUERY1 WHERE CRITERIA MET AND job = *passedinjob
INSERT username INTO TABLE1 FROM QUERY2 WHERE CRITERIA MET AND job = *passedinjob AND username NOT IN TABLE1
SELECT username FROM TABLE1 and put in a dataset
[Code] .....

There were no UNION statements in the query1 or query2, there was no select count(*) from table, there was no recordset.count..