Can someone tell me how to get around this? When I include "[Command
Structure].UNIT" in this query, I get the "UNIT not part of an
aggregate query" message. When I take it out, the query runs fine.
Unfortunately, I really need that field in my query results.

Thanks in advance.

SELECT PMARS_Data_Trimmed.UIC3, Sum(CInt(PMARS_Data_Trimmed.IDT)) AS
IDT_Participation, [Command Structure].UNIT, [Command Structure].MSC,
(Sum(CInt(PMARS_Data_Trimmed.Strength))*4) AS IDT_Potential,
Sum(CInt(PMARS_Data_Trimmed.IDT))/(Sum(CInt(PMARS_Data_Trimmed.Strength))*4)
AS IDT_Participation_Rate
FROM PMARS_Data_Trimmed INNER JOIN [Command Structure] ON
PMARS_Data_Trimmed.UIC3=Mid$([Command Structure].UIC,2,3)
GROUP BY PMARS_Data_Trimmed.UIC3, [Command Structure].MSC
ORDER BY PMARS_Data_Trimmed.UIC3;

Thank you, Noam!

I didn't realize that nor do I understand why it is. But it worked!

John