>A query like this would clean them out, but it might take a while to process:
>Where CallDate < '4/1/98'
> And Not Exists
> ( Select AccountID
> From SubAccounts
> Where Calls.Usernmame = SubAccounts.Login
> Or Calls.Usernmame = SubAccounts.Shell
> Or Calls.Usernmame = SubAccounts.EMail
Usernmame is not a valid column. It took me 4 hours to finally see that
Michael J. Whisenant
AIRnet Internet Services, Inc.
ph: (256) 704-4692 fax: (256) 704-2329