I am using Access 2000 database for calibration control of measuring instruments. i.e. micrometers, calipers etc. The precision of the instruments varies and the decimal data fields in the table are set to Auto to minimize the stored values without changing the accuracy.
I want to change the number of decimal places displayed in the individual instrument report using an IF statement where the critera is controlled by the decimal precision required for the specific instrument.
So far I have not found the command to set decimal in VB let alone structue the entire IF statement.
September 18, 2009 11:55 AM
September 21, 2009 1:51 PM