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