Re: [Emerald] QUERY HELP!

Dale E. Reed Jr. ( (no email) )
Sat, 26 Feb 2000 11:51:55 -0800

PowerNet wrote:
>
> Dale,
>
> The expired accounts worked, but the inactive accounts one did not.

Sorry. The field is just Active, not maActive:

Select CustomerID From MasterAccounts Where Active = 0

-- 

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