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 Job Number of Jobs for this type and site Number of jobs for this site Percent of the type of jobs for this site Guess it would be something like: SELECT SiteCode, TypeOfJob, count(TypeOfJob) As countJobType FROM jobs GROUP BY SiteCode But I cannot work out how to work out the number of jobs for the site. Please help! Thanx!
