--- Original Message -
From: "Rhino" <[EMAIL PROTECTED]>
To: "Ed Reed" <[EMAIL PROTECTED]>;
Sent: Friday, September 09, 2005 6:26 PM
Subject: Re: Simple Count Query
> I think you want this or something similar:
>
> select count(distinct fld2)
> from yourtab
I think you want this or something similar:
select count(distinct fld2)
from yourtable
where fld4 = 'am';
N.B. I have not tested this solution.
Rhino
- Original Message -
From: "Ed Reed" <[EMAIL PROTECTED]>
To:
Sent: Friday, September 09, 2005 6:08 PM
Subje
I know this has to be a simple query but its really kickin' my butt. I have the
table below where fld1 is the year, fld2 is a number, fld 3 is a subnumber, and
fld4 is the user. I need to know the count of all the records for user am
without the sub number getting in the way. For example, the f
