Re: [Emerald] need sql qry to find expired accounts

Dale E. Reed Jr. ( (no email) )
Wed, 28 Apr 1999 15:06:58 -0700

> "(Ken)" wrote:
> need an sql query to find all accounts that expired 2 months ago.
> when i use the maaccountexp field from master accouts it isnot right
> for some reason...

If you are using Balance Forward, then there isn't an expire date
on the account. Otherwise this should work:

Select CustomerID, FirstName, LastName