[RESOLVED] VB6 (Access) SQL Question

[dglienna]

I have 2 SQL Queries that I'd like to combine.

First, I get BatchDate and Closed Totals.

SELECT DISTINCTROW Transactions.BatchDate, Count(Transactions.BatchDate) AS [OpenTotal]
FROM Transactions
WHERE (((Transactions.DeletedFlag)=0))
GROUP BY Transactions.BatchDate;

and this gets BatchDate and Open Totals

SELECT DISTINCTROW Transactions.BatchDate, Count(Transactions.BatchDate) AS [ClosedTotal]
FROM Transactions
WHERE (((Transactions.DeletedFlag)=1))
GROUP BY Transactions.BatchDate;

How could I combine this to get:

BatchDate, OpenTotal, ClosedTotal

instead of two different RecordSets?

Thanks.