[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