> > select Login, Calls.AcctsessionTime
> > from Calls, SubAccounts
> > where SubAccounts.Login = Calls.Username
> > and AccountType = 'Minute Charge'
You'd have to bring in the MasterAccounts table (linked via
CustomerID) and then you could display the CC information.
You can use the record select expert to limit the scope of
Calls.CallDate. There are several functions like last full month,
which might work.
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