2 Queries and a Form, Please assist

[cross5900]

This is probably more easier than my brain is allowing it to be. I have 2 queries

AccountsClosedToday_qry

SELECT UCase(Users.UserName) AS Associate, Count(Information_tbl.IsActive) AS [Closed Today]
FROM Information_tbl INNER JOIN Users ON Information_tbl.Associate = Users.UserID
GROUP BY Users.UserName, Information_tbl.ClosedDate
HAVING (((Count(Information_tbl.IsActive))=True) AND ((Information_tbl.ClosedDate)=Date()));

AccountsClosedTotal_qry

SELECT UCase(Users.UserName) AS Associate, Count(Information_tbl.ClosedDate) AS [Total Closed]
FROM Information_tbl INNER JOIN Users ON Information_tbl.Associate = Users.UserID
GROUP BY Users.UserName, Information_tbl.IsActive
HAVING (((Information_tbl.IsActive)=True))
ORDER BY Count(Information_tbl.ClosedDate) DESC;

I am wanting to get the results from 'Closed Today' and 'Total Closed' onto one form. I am thinking I may have to create a table and have this information either go through an append or an update query each time the database is loaded, I am sure there is a better way of this which is why I am posting here. Thanks.

 

[KeithG]

you can make a third query to get the information into one query.