datalink Posted January 11, 2008 Posted January 11, 2008 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.
David Jondreau Posted January 11, 2008 Posted January 11, 2008 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.
Lee Smith Posted January 12, 2008 Posted January 12, 2008 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
datalink Posted January 12, 2008 Author Posted January 12, 2008 Works like a charm. Thanks very much. I really appreciate it.
Recommended Posts
This topic is 6221 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now