AlaNio
10-14-2008, 05:59 AM
I need an sql statement that checks to see if certain fields are blank and if not then do something else.
For example i have a field named comission and a field named fixedfee. Neither of which will both have values at the same time. If the record has a commission, then multiply that by the price, if it does not then use the fixed fee. Then return the sum of all these.
For example i have a field named comission and a field named fixedfee. Neither of which will both have values at the same time. If the record has a commission, then multiply that by the price, if it does not then use the fixed fee. Then return the sum of all these.