incremental validation rule

[BadKitty]

one of my tables has a field called # of Days. the default (minimum) value for this field is five (5), which i set. however, if there is a case where five (5) days are not enough, the next value would be ten (10) since the permit is issued for 5 days at a time, and so on. can someone suggest a validation rule that only allows increments of 5, but the minimum value is never less than 5? thanx in advance!

 

[ScottGem]

Use the Mod operator. something like

MOD 5 = 0

MOD returns the remainder of a division. If the entered number, when divided by 5, leave a remainder other than 0 then its in invalid entry.