2. ASPRunnerPro General questions
  3. Help with Charts
This topic is locked

Help with Charts

 		7/29/2009 2:43:29 AM
ASPRunnerPro General questions
A
 Aussie Mick author

Another question folks..
I have a table that is called Call Log.
Items are entered into the call log with the following fields
Name,

Branch,

Area,

Hire_Agreement_Number,

Opportunity_Improvement,

Further_Information,

Description_of_Opportunity,

[Date],

Corrective_Action_Taken,

Preventative_Action_Suggested,

Preventative_Action_Taken,

Call_Status
Under area it will have different regions.
I would like to write an sql query to list number of Calls Open by region... so
ie vic 6 calls

nsw 4 call
what woudl be the SQL statement, I have been working on this all afternoon..
Thanks folks.
Mick
J
 		Jane 7/29/2009

Here is just a sample:

select count(*),

Area

from [Call log]

group by Area
A
 		Aussie Mick author 7/29/2009

Thanks Jane, that worked perfectly <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=43096&image=1&table=forumreplies' class='bbc_emoticon' alt=':rolleyes:' />