is it possible to have an if statement on a text box control source. I trying to calculate regular and ot hours in a payroll report, the report grabs at the time cards from each employee and calculates there cumulative time, but I want to be able to check if a days hours is over 8 hours that regular hours equals 8 hours and the rest is ot hours, and if the weeks hours are over forty the rest are ot. I think i could accomplish this with if statements but I cant figure out if they are allowed on text box control sources. If they are could someone supply examples? if they aren't any one have ideas how I can do this.
if statement on control source
- Thread starter abbers_01
- Start date
