-- Report - Number of Cards
SELECT Linked_Members.MEMBERSHIP_TYPES.MEMBERSHIP_TYPE, COUNT(*) AS [COUNT]
FROM Linked_Members
WHERE (Linked_Members.ISSUE_DATE>=[Start_Date_Param]) And (Linked_Members.ISSUE_DATE<[Stop_Date_Param])
GROUP BY Linked_Members.MEMBERSHIP_TYPES.MEMBERSHIP_TYPE;
 
-- Report - Total Number of Certificates
SELECT COUNT(*) AS [Total Number of Certificates Issued]
FROM Certificates AS Certificates
WHERE (Certificates.Date>=[START_DATE_PARAM]) And (Certificates.Date<[STOP_DATE_PARAM]);