Stuart McLachlan
stuart at lexacorp.com.pg
Sun May 22 23:25:36 CDT 2005
On 23 May 2005 at 0:00, John W. Colby wrote:
> Do NOT hard code the values in code. Build a table of From/To/Commission.
> This will allow you to tweak your commissions as desired by changing values
> in the table.
>
Good point.
Then you can calculate commission using something like:
Dlookup("Commission","tblCommissions","FromSale <= " & Sales & " AND ToSale
=> " & Sales)
(Note. Do NOT use From or To as the field names. Using reserved words for
field names can cause you all sorts of trouble)
--
Stuart