[AccessD] Reorder Level

Evidently I am missing something all together. I changed the OnCurrent
to what you mentioned & I still have the same results. It shows the Item
is 18 units below minimum level.

ReorderLevel: 14
txtOnHand: 496
txtOnOrder: 500
txtReorderLevel: 18
=IIf(([txtOnOrder]-[txtOnHand])+[ReorderLevel]>0,([txtOnOrder]-[txtOnHan
d])+[ReorderLevel],0)

 

________________________________

  What you want is to change the check:
 
   If OnHand + OnOrder <  ReorderLevel then
      ' Need to re-order
     <reorder amount> = ReorderLevel - (OnHand + OnOrder)
   Else
     <reorder amount> = 0
   End If
 
Jim
 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
<http://databaseadvisors.com/mailman/listinfo/accessd> 
[mailto:accessd-bounces at databaseadvisors.com
<http://databaseadvisors.com/mailman/listinfo/accessd> ] On Behalf Of
Hollis, Virginia
Sent: Tuesday, November 10, 2009 11:17 AM
To: accessd at databaseadvisors.com
<http://databaseadvisors.com/mailman/listinfo/accessd> 
Subject: [AccessD] Reorder Level
 
Ok, that doesn't seem to work either. It doesn't show the negatives
(which is good). But it shows the minimum level is low when it isn't -
they have too much of this item.
 
I get:
Reorder Level: 14
On Hand: 496
On Order: 500
txtReorderLevel: 18
Message - "Item is 18 units below minimum level". When actually they
have 996 items when the minimum is 14. They are overstocked.