The following gives me what I originally wanted - all records matching the criteria.
Code: Select all
SELECT ISSUES.RECORDNUM, ISSUES.MEDICAL_GROUP, ISSUES.HMO, ISSUES.SPECIFIC_ISSUE, ISSUES.MEMBER_LAST_NAME, ISSUES.MEMBER_FIRST_NAME, ISSUES.DOB, ISSUES.MEMBER_IDNUM, ISSUES.MEMBER_CODE, ISSUES.MRN, ISSUES.OPENING_NOTES, ISSUES.HMO_NOTIFIED1
FROM ISSUES
WHERE (((ISSUES.DATE_ISSUE_OPENED)<#2/11/2010#))
GROUP BY ISSUES.RECORDNUM, ISSUES.MEDICAL_GROUP, ISSUES.HMO, ISSUES.SPECIFIC_ISSUE, ISSUES.MEMBER_LAST_NAME, ISSUES.MEMBER_FIRST_NAME, ISSUES.DOB, ISSUES.MEMBER_IDNUM, ISSUES.MEMBER_CODE, ISSUES.MRN, ISSUES.OPENING_NOTES, ISSUES.HMO_NOTIFIED1, ISSUES.DATE_RESOLVED
HAVING (((ISSUES.DATE_RESOLVED) Is Null))
ORDER BY ISSUES.MEDICAL_GROUP, ISSUES.HMO;
HMO = AE
and
Specific_Issue = Closed Practice
Thank you very much for your help.
Michael Abrams