I am trying to distinctly count the number occurences of jobs for
different agencies in my application. The query spits back all records
giving the total in the system being 47 and listing it 47 times against
each agency. This obviously is not what I want. How do I get the output
to read
Agency 1
u the number of times an agency has Incomplete associated
with it.
chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com
-Original Message-
From: James Taavon [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 10, 2001 4:07 PM
To: CF-Talk
Subject: What sho
SELECT Functubakthing, Count(Functubakthing) AS Count
FROM Table
GROUP BY Functubakthing
hth
e
From: James Taavon <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Subject: What should be easy has eluded me...
Date: Wed, 10 Jan 2001 16:06:53 -0500
I
-Original Message-
> From: James Taavon [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 10, 2001 4:07 PM
> To: CF-Talk
> Subject: What should be easy has eluded me...
>
> I am trying to distinctly count the number occurences of jobs for
> different agencies in my
4 matches
Mail list logo