In a form (Form1) a user enters a date and in a subform (Query1 subform) which is based on a query i see the records from a table filtered by that date. In the subform I would like to write a function to sum the numbers of days worked by an employee and if the result is above ten I would like the lines containing the employee to turn red or maybe the Days fields for that employee. Any advice will be appreciated.