Hey guys just wondering if anyone could give me some ideas on what I'm trying to achieve. I have 7 repeating tables where each one represents a day of the week. The form is for engineers and they put in their jobs they attend for that they. The tables have the same columns for each. At the bottom of the form I have a text box which needs to calculate the total hours for a job if the job is a installation job. An example is shown below:
Work Description - Job No - Work Code - Total hours on site
I have tried multiple ways to set up a rule where If work code = I (insallation) then sum up the hours with the rest of the installation jobs for the rest of the week and display in a text box. Just wondered what would be the simplist way to achieve this?