Remove the trailing comma from the SELECT clause:
SELECT CallDtl: IIf(IsOther, "Other", tblIncidentLog.[CallDetail]),
Count(tblIncidentLog.CallDetail) AS CountOfCallDetail
FROM tblIncidentLog JOIN tblDetails ON tblIncidentLog.CallDetail =
tblDetails.CallDetail
WHERE tblIncidentLog.Date Between [Forms].[frmDistrictReport].[Start]
And [Forms].[frmDistrictReport].[End]
GROUP BY IIf(IsOther, "Other", tblIncidentLog.[CallDetail]);

--
Duane Hookom
Microsoft Access MVP


"pushrodengine via AccessMonster.com" wrote:

Try replace reserved words in your objects. For instance END is a reserved
word. START might also cause issues but probably not here.

Otherwise see what happens if you remove tblDetails.

No change, same problems.

Thanks

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200812/1