[AccessD] (no subject) - Commissions

My .02:
Also be ready to re-write this business rule.  The whole approach would
more fairly be based on total dollar of sales, not number of sales. (A
$1 sale gets the same weight as $10,000 currently.) I see sales people
demanding this change in your future.



Steve


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W. Colby
Sent: Monday, May 23, 2005 7:46 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] (no subject)


>(Note. Do NOT use From or To as the field names.  Using reserved words 
>for
field names can cause you all sorts of trouble)

ROTFL.  SO TRUE.  Bad John!

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
McLachlan
Sent: Monday, May 23, 2005 12:26 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] (no subject)


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


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com