>Elgin, try this:
>
>SELECT Client.ClientID, client.state, cnt(Invoices.ClientID) as NumInv;
> FROM Client, Invoices;
> WHERE client.clientid = invoices.clientid;
> AND client.state = 'CA';
> into cursor CurTemp;
> Group by ClientID having NumInv > 50
>
>
>Of course, I used California since I couldn't remember the abbreviation for Arkansas :-)
>
>Anyway, check out the HAVING clause. It's really useful.
>
>HTH
>Barbara
Barbara,
Thanks so much for the speedy response. I'll give your code a try.
I'm new to the Universal Thread World, but I think it's the best thing I've seen since the old Compuserve forums. Today's my first day on it, and I've been here for over 3 hours now. I willl definitely be subscribing. Thanks again.