January 11, 200818 yr This shouldn't be tough but its been a long day and I'm feeling a bit fried. In a script using and if statement I need a calculation that will check to be certain that the contents of a number field end in either .00, .0, .25, .5, .50, or .75. So and entry of 8.5 is valid and an entry of 8.3 isn't. Its being used for timesheet entry. Thanks for any help anyone might have.
January 11, 200818 yr Int(field*4) = field*4 BTW the decimal portion of a number field will never end in zero. Or, I guess, it always ends in a bunch of zeroes.
January 12, 200818 yr Its being used for timesheet entry. You might want to look at Rounding the Times instead of Lopping off the numbers, or forcing the user to re-impute the data until they get it right. There are several Round Up time examples around, start by looking at the files available at John Mark Osborne site Here
Create an account or sign in to comment