Re: [Emerald] Report

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

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Gary Wilkinson: "[Emerald] Report"
Next message: Gary Wilkinson: "Re: [Emerald] Report"
Maybe in reply to: Gary Wilkinson: "[Emerald] Report"
Next in thread: Gary Wilkinson: "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

Previous message: Gary Wilkinson: "[Emerald] Report"
Next message: Gary Wilkinson: "Re: [Emerald] Report"
Maybe in reply to: Gary Wilkinson: "[Emerald] Report"
Next in thread: Gary Wilkinson: "Re: [Emerald] Report"