I have a simple monthly accounting report which is based on a query, which in turn is based on a parameter query. In the report footer I am trying to use the DSun function to sum up the values in one field, but I keep getting an error. I did a little reading and found that you cannot use the DSun fnction in a report based on a parameter query. I know however that at some of you gurus out there have found a way around this obsticle. Please be so kind as to share the benefits of your knowledge and exerience with this lowly novice.