I am looking at these peoples accounts and it seems we have had incidents=
with them, but can't figure out why they are on this list.
What does non-bill accounts mean and why would users be on it?
Thanks,
John
*********** REPLY SEPARATOR ***********
On 2/26/00, at 10:51 AM, Dale E. Reed Jr. wrote:
>PowerNet wrote:
>>
>> What Query would I use to find all inactive accounts?
>
>Select CustomerID From MasterAccounts Where maActive =3D 0
>
>> What Query would I use for all expired accounts?
>
>Select CustomerID From MasterAccounts Where maExpireDate < GetDate()
>
>The later doesn't take into consideration extensions/limits, though.
>
>
>--
>
>Dale E. Reed Jr. Emerald and RadiusNT
>__________________________________________
>IEA Software, Inc. www.iea-software.com
>
>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