I am using Access 97. I have a main form call DEMM Form. I have 7 subforms in the DEMM form. Each of these subforms are linked to pull up information on a specific project. I have a total field in the subform.
Everything works fine, except when there is no data to total, #Error shows up in the total field. How can I change it so it doesn't say #Error? Ideally, it should show 0.