var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Access 2002 range in a form
Is it possible to calculate the range of three cells from data entered in a form within the same record? Would I use the MAX/MIN or Dmax/Dmin functions to calculate the range?
range is usually between two points, no? What data type are the three values?
I am looking for the range of the three values using a max and min function
sorry I am still waking up. If you are needing the range for three, you would need to write some function that looks at each value and then just subtracts the greatest and least values. Max()would give you just the max value in some field.
I agree with what you are saying, but how do I create the formula to make this happen?
I just found an easier way, maybe. In your fourth textbox set the control source to:
=Choose(Max(),[Coating Thickness A 1],[Coating Thickness A 2],[Coating Thickness A 3]))-Choose(Min(),[Coating Thickness A 1],[Coating Thickness A 2],[Coating Thickness A 3])
And still can not seem to get it to work. Am I just being blinded by the numbers?
Thanks for your help
The stuff in the brackets should be the names of the actual text boxes, not your field names.
I had changed the text box names to match the field names due to the complexity of the DB.
Last edited by ahoop; 08-22-07 at
I would name them like txtboxCoatT1,...2,...3