Re: [Emerald] Report

Dale E. Reed Jr. ( (no email) )
Tue, 30 Mar 1999 13:58:38 -0800

> Gary Wilkinson wrote:
> I am currently writing a report and I need to find the information in
> the tables that determines if the user is going to be charged a
> connection fee.
> Could someone point me in the correct direction.

Do you mean a setup fee? You need to see if the ChargeTypeID
is NULL or null for their account type. If its not NULL, then
find that ID from the ChargeTypes table and thats the setup
charge. Like:

Select SubAccounts.Login, AccountTypes.AccountType, AccountTypes.Cost,