select * from masteraccounts where active = 1 and maexpiredate < getdate()
Charles
----- Original Message -----
From: Don Barron <don@world-link.com.au>
To: <emerald@iea-software.com>
Sent: Saturday, August 14, 1999 1:35 AM
Subject: [Emerald] Report
> Hi,
>
>
> Does anyone have a report that I could have a copy of that will print me
out
> a full list including all details about users who are ticked active and
> there expire is has not expired ?
>
> Thanks
>
> ----------------------------------------
> Don Barron
> Network Administrator
> World-Link Internet
>
> Ph: (08) 8231 0999
> Fax: (08) 8212 8805
>
> don@world-link.com.au
> http://www.world-link.com.au
> ----------------------------------------
>
>
> 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