[AccessD] Reorder Level

Oh! Never mind. I got it - added a parenthesis. Thanks!

 

From: Hollis, Virginia 
Sent: Wednesday, November 11, 2009 1:46 PM
To: 'accessd at databaseadvisors.com'
Subject: [AccessD] Reorder Level

 

I placed this in the Control Source of the text box - txtReorderAmt. I
get an error - "the expression in the function contains the wrong number
of arguments."

 

 

*************

Maybe I'm missing the point, but I believe it should be this:

 

=IIf([txtOnHand]+[txtOnOrder])<[ReorderLevel],[ReorderLevel]-([txtOnHand
])+[txtOnOrder],0)

 

=(496 + 500) < 18 ,  18 - (496 + 500) , 0

 

  so you'd get 0 in this case.