Hello,
I am using Access XP (2002) SP3. I've created a table that is to store the details of certain shipments. Some shipments are measured in terms of pieces shipped, whereas in other cases the shipment is measured in kilograms. This being the case, I have one field called 'MeasurementUnit' that contains the measurement unit (i.e. pieces or kilograms) and another called 'Quantity' that contains the number of units shipped. I want a validation rule for 'Quantity' that disallows fractional numbers if the field 'MeasurementUnit' for that record contains the value 'pieces'. For this, I believe that I'd need to reference, in the validation rule, the value contained in the MeasurementUnit field of the current record. How is this done?
I'd much appreciate any help.
Thanks!