The expired accounts worked, but the inactive accounts one did not.
Any ideas?
Thanks.
*********** 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 = 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