Regards Gary
-----Original Message-----
From: Dale E. Reed Jr. <daler@iea-software.com>
To: emerald@iea-software.com <emerald@iea-software.com>
Date: Wednesday, 31 March 1999 8:01
Subject: Re: [Emerald] Report
>> 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,
>ChargeTypes.Amount
>From SubAccounts, AccountTypes, ChargeTypes
>Where SubAccounts.AccountType = AcountTypes.AccountType
> and AccountType.ChargeTypeID *= ChargeTypes.ChargeTypeID
>
>
>--
>
>Dale E. Reed Jr. Emerald and RadiusNT
>__________________________________________
>IEA Software, Inc. www.iea-software.com
>
>For more information about this list, including removal,
>please see http://www.iea-software.com/maillist.html
For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html