What should be easy has eluded me...

2001-01-10 Thread James Taavon
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

RE: What should be easy has eluded me...

2001-01-10 Thread Christopher Olive, CIO
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

Re: What should be easy has eluded me...

2001-01-11 Thread Eric Dawson
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

Re: What should be easy has eluded me...

2001-01-11 Thread James Taavon
-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