Rhino wrote:
SELECT SiteCode, TypeOfJob, count(TypeOfJob) As countJobType FROM
jobs GROUP
BY SiteCode
I think he wants something like
select SiteCode, TypeOfJob, count(TypeOfJob) As countJobType, (select *
from jobs) as alljobs, countJobType*100.0/alljobs FROM jobs GROUP BY
SiteCode
I'm pre
- Original Message -
From: "Zack Vernon" <[EMAIL PROTECTED]>
To:
Sent: Sunday, March 19, 2006 12:11 PM
Subject: Counting Multiple Fields
Hello,
Would be grateful for any help!
I have a table like (in reality few more fields!!!):
Id Site Code
Hello,
Would be grateful for any help!
I have a table like (in reality few more fields!!!):
Id Site Code Type of Job
What I want to do is make reports like:
Site Code Type of JobNumber of Jobs for this type and site
Number of jobs for this site
