Minimum and Maximum

[Mike Powell]

I have a table showing 15 chemical levels taken on a daily basis. Each row being the next days readings. What I want to do is to create another table which has minimum and maximum levels for the chemical in that field. i.e. Silicon in the table is 3, 3.05, 3.15 etc. The min level could be 2.6 and the max could be 4.0. I would like to know as soon as I input the figures if possible.


Thanks,

Mike

 

[Jack Cowley]

Create a table with a field for the chemical name (or whatever you use), a field for minimum value and a field for maximum value. In your forms Before Update event have code look at this table and see if the value is less than the minimum or greater than the maximum. If it is then tell the user and undo their input.

hth,
Jack