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 |
#22
|
|||
|
|||
Graphing an "Other" section in a Pie Graph
I get another error:
“The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect” -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200812/1 |
#23
|
|||
|
|||
Graphing an "Other" section in a Pie Graph
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. -- Duane Hookom Microsoft Access MVP "pushrodengine via AccessMonster.com" wrote: I get another error: “The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect” -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200812/1 |
#24
|
|||
|
|||
Graphing an "Other" section in a Pie Graph
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 |
#25
|
|||
|
|||
Graphing an "Other" section in a Pie Graph
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 |
#26
|
|||
|
|||
Graphing an "Other" section in a Pie Graph
I get the following error:
Syntax error (missing operator) in query expression ‘CallDtl: IIf(IsOther, “Other”, tblIncidentLog.[CallDetail])’. -- Message posted via http://www.accessmonster.com |
#27
|
|||
|
|||
Graphing an "Other" section in a Pie Graph
Could you reply with your full sql statement? Are the quote marks true quotes
or some other variation? Your reply states: “Other”, where I would expect: "Other", Notice the difference? -- Duane Hookom Microsoft Access MVP "pushrodengine via AccessMonster.com" wrote: I get the following error: Syntax error (missing operator) in query expression ‘CallDtl: IIf(IsOther, “Other”, tblIncidentLog.[CallDetail])’. -- Message posted via http://www.accessmonster.com |
#28
|
|||
|
|||
Graphing an "Other" section in a Pie Graph
Notice the difference?
Yes I do. Below is the actual error (the difference is in the font type) I get the following error: Syntax error (missing operator) in query expression 'CallDtl: IIf(IsOther, "Other",tblIncidentLog.[CallDetail])'. -- Message posted via http://www.accessmonster.com |
#29
|
|||
|
|||
Graphing an "Other" section in a Pie Graph
Again:
Could you reply with your full sql statement? There should be nothing wrong with the expression in your reply. We need to see it in context. -- Duane Hookom Microsoft Access MVP "pushrodengine via AccessMonster.com" wrote: Notice the difference? Yes I do. Below is the actual error (the difference is in the font type) I get the following error: Syntax error (missing operator) in query expression 'CallDtl: IIf(IsOther, "Other",tblIncidentLog.[CallDetail])'. -- Message posted via http://www.accessmonster.com |
#30
|
|||
|
|||
Graphing an "Other" section in a Pie Graph
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 |
Thread Tools | |
Display Modes | |
|
|