save min value between 3 fields on a form not a table

  • Thread starter Thread starter Blair168412
  • Start date Start date
B

Blair168412

the 3 fields are s-1, s-2, s-3 all have the same properties numbers and I
want to find the minimum value ans stote it in MinVal field from one record
on a form
 
If you can 'calculate' the minimum, don't bother storing it in a table!
After all, if someone makes a change (correcting an error, making an error,
whatever), your stored "minimum" would then be out of sync!

Instead, use a query (or the form) to calculate the minimum on-the-fly, for
display purposes.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top