Again:
Could you reply with your full sql statement?
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]);
I just copied your rely into SQL.
Is there a way you could send me an example of graphing “other”?
Thanks
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200812/1