It pulled up way too many services.
*********** REPLY SEPARATOR ***********
On 3/29/00, at 5:57 PM, Bernard Andrys wrote:
>I use this in Access (note that dbo_Subaccounts is an odbc link to
>SELECT Count(dbo_SubAccounts.Active) AS CountOfActive,
>GROUP BY dbo_SubAccounts.AccountType;
>> -----Original Message-----
>> From: firstname.lastname@example.org
>> [mailto:email@example.com]On Behalf Of PowerNet
>> Sent: Wednesday, March 29, 2000 5:35 PM
>> To: firstname.lastname@example.org
>> Subject: [Emerald] Script
>> I am looking for an SQL query that will display the number of
>> active customers by service type.
>> Can anyone help.
>> For more information about this list (including removal) go to:
>For more information about this list (including removal) go to:
For more information about this list (including removal) go to: