I have three queries set up. I would like to show how many stores opened and closed per contract.
one query for opened stores:
SELECT tblContractStore.intContractID, Count(tblContractStore.intStoreID) AS CountOfintStoreID
FROM tblContractStore
WHERE (((tblContractStore.dtmCloseDate) Is Null))
GROUP BY tblContractStore.intContractID;
and one query for closed stores:
SELECT tblContractStore.intContractID, Count(tblContractStore.intStoreID) AS CountOfintStoreID
FROM tblContractStore
WHERE (((tblContractStore.dtmCloseDate) Is Not Null))
GROUP BY tblContractStore.intContractID;
When I add the queries above to the third query it only shows the contracts with closed stores. How do I get it to show how many stores were opened and closed per contract?
one query for opened stores:
SELECT tblContractStore.intContractID, Count(tblContractStore.intStoreID) AS CountOfintStoreID
FROM tblContractStore
WHERE (((tblContractStore.dtmCloseDate) Is Null))
GROUP BY tblContractStore.intContractID;
and one query for closed stores:
SELECT tblContractStore.intContractID, Count(tblContractStore.intStoreID) AS CountOfintStoreID
FROM tblContractStore
WHERE (((tblContractStore.dtmCloseDate) Is Not Null))
GROUP BY tblContractStore.intContractID;
When I add the queries above to the third query it only shows the contracts with closed stores. How do I get it to show how many stores were opened and closed per contract?