I have a table in a subform that has drop-down list that includes the days of the weeks as well as a numeric field to enter in hours. Users can add in another row by clicking an Add button. I would like to create several calculated fields, one for each day of the week that will act as a grand total for each day. Can anyone help me? I have not been able to find an example of this anywhere.
Thank you.