Access Report Sum Error from Crosstab Query
Posted on 2008-11-14
I am having problems adding up totals in my report colums. What I have is a query that does some basic selects, then a crosstab query groups the data I need for me and counts things up nicely. I can then use the crosstab query as the control source for the report. My data isin't very complex:
Manager name Station Compliant Non Compliant
so the manger names are grouped together so the numeric values in Compliant and Non Compliant are grouped counts by the manager name. On my report in the Page footer or in the report footer I would like to sum the compliant and the Non Compliant over all. Not by the manager, but just add up everything in the column.
I can get all the information to display correctly except the totals where I get #Error on the report. I thought it was possibly a spelling mistake (in my page footer I have a text box with "=sum(Nz(Compliant))") but that was not the case. The text box that I want to sum up is called Compliant in the detail header. There are some null values in the column so I thought I needed the Nz. I also tried to sum the control source value which is called "0" zero
Not sure what I am doing wrong, I am new to access and report building