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
>SubAccounts):
>
>SELECT Count(dbo_SubAccounts.Active) AS CountOfActive,
>dbo_SubAccounts.AccountType
>FROM dbo_SubAccounts
>WHERE ((dbo_SubAccounts.Active)=1)
>GROUP BY dbo_SubAccounts.AccountType;
>
>> -----Original Message-----
>> From: emerald-request@iea-software.com
>> [mailto:emerald-request@iea-software.com]On Behalf Of PowerNet
>> Sent: Wednesday, March 29, 2000 5:35 PM
>> To: emerald@iea-software.com
>> Subject: [Emerald] Script
>>
>>
>> I am looking for an SQL query that will display the number of
>> active customers by service type.
>>
>> Can anyone help.
>>
>> Thanks.
>> John
>>
>>
>> For more information about this list (including removal) go to:
>> http://www.iea-software.com/support/maillists/liststart
>>
>
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart