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