Most clients who sell their items on ebay will have their final
commission rate determined by the final selling price of the item
that is, a "sliding scale" of commission. So, for example, an item
that closes between $0.99 and $999 AU has a 21% commission rate;
each price bracket thereafter has a different commission rate
assigned.
This means that I need (presumably) an If statement that will
calculate the appropriate commission rate based on the final selling
price of the item. So:
If tblSales_FinalSalePriceAU =<999,
Then tblSales_CommRate = 21%
etc.
The next problem is that some clients have a "permanent" commission
rate. So, if [tblClients_Trade(Y/N)] has a value of Yes, then an
adjoining field [tblClients_CommAmt] can have an
optional "permanent" value of, say, 15%.
When calculations occur later in the database (to determine
profit/loss, amount payable to clients, etc), any value that has
been entered into [tblClients_CommAmt] needs to `override' the
default sliding commission rate (in [tblSales_CommRate]) that would
automatically be calculated from the final selling price.
How would I best achieve these functions?
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
