Thank James. The query is correct as I had it. It only pulled the names in that date range. So I get a count for each person.

The below is a sample of the #temptableI created queries for different temptables to get column results for the main temp table.UserID SalesTeamID SalesTeamName DayWithoutSale WeeklyApps Leases11 2 Roman 37 2 NULL28 1 Quentin NULL 10 5

There are no NULL returns in the queries when they are in their own specific temp table. I get NULLS when main temp table is updated with all the other temp tables.

I hope that is clearer. What you wrote the first time I couldn't see how to apply it.

Thank James. The query is correct as I had it. It only pulled the names in that date range. So I get a count for each person.

The below is a sample of the #temptableI created queries for different temptables to get column results for the main temp table.UserID SalesTeamID SalesTeamName DayWithoutSale WeeklyApps Leases11 2 Roman 37 2 NULL28 1 Quentin NULL 10 5

There are no NULL returns in the queries when they are in their own specific temp table. I get NULLS when main temp table is updated with all the other temp tables.

I hope that is clearer. What you wrote the first time I couldn't see how to apply it.

I couldn't see how you would get nulls in your result. You have count of specific column, and that will some number that is 0 or greater. It wouldn't return null. Can you show an example of how you are getting the null?