If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
Graphing an "Other" section in a Pie Graph
What do you get from:
SELECT IsOther, 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 IsOther, tblIncidentLog.[CallDetail]; -- Duane Hookom Microsoft Access MVP "pushrodengine via AccessMonster.com" wrote: 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 tried the expression and got another error that reads: “Syntax error (missing operator) in query expression ‘CallDtl: IIf(IsOther, “Other”, tblIncidentLog.[CallDetail])’." -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200812/1 |
Thread Tools | |
Display Modes | |
|
|