If it doesn't matter which mission statement you get for the group, then try
SELECT tblOrganization.Org_ID, tblOrganization.Org_Abbreviation,
First(tblOrganization.Org_MissionStatement) as MissionStatement
FROM tblOrganization
GROUP BY tblOrganization.Org_ID, tblOrganization.Org_Abbreviation
I really don't see the point of using an aggregate query in the above SQL.
I would think that ORG_ID would be unique within the table and therefore all
you would really need would be a standard select query.
SELECT tblOrganization.Org_ID
, tblOrganization.Org_Abbreviation
, tblOrganization.Org_MissionStatement
FROM tblOrganization
--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..