Pivot Table Calculation Returns Zeros.

[khughes46]

I am trying to create a pivot table to show total absences. Each absence is an individual occurrence with a with a count of 1 in the attendance column. All I need for the table is the ID and the Attendance; ID is my row and attendance is what I need to be summarized but I just keep getting a zero in each place where the Attendance is a 1. This works well in Excel. What is different here?

[ranman256]

check the query and make sure you are SUMMING the attendance col.

[khughes46]

That was it. Thanks.