First, I must say thanks to everyone contributing to this site. I have a parent form containing some financial information with dates and name fields. I also have a child subform with more detailed financial records including a dollar amount in the records. I have a total field in the subform footer and the totals appear except when the above records in the subform are Zero then there is nothing in the calculated total. I am trying to use this information in reports and in the report I also see nothing from the subform if the value is zero. I will attach a clip of the form. Thanks