I created a report in VB 2005 Report Viewer the dataset is from  an Access mdb table . The fields I want to total isl set to currency format in the table and the report.  The report is a simple one and I  just want to total one field. I use
=Sum(Fields!PurchasePrice.Value). When I run the report I receive an #Error at where the total should be . Anyone have a clue what the issue could be. The Sum statement is located at the footer.