SELECT DISTINCT Trim(UCase([School Contact Names Query]![Group])) AS [Group], [School Contact Names Query].contact, Trim(UCase([groups]![address1])) AS address1, groups.address2, Trim(UCase([groups]![city])) AS city, groups.state, groups.zip, groups.school
FROM [School Contact Names Query] INNER JOIN groups ON [School Contact Names Query].Group = groups.group
WHERE (((groups.school)=True))
ORDER BY Trim(UCase([School Contact Names Query]![Group]));