I'm no expert on Access (I use FoxPro) but totals definitely need to be in the Page Footer (not Detail) band. You say you got an error when you tried this. What was the error? Make sure the total field is wide enough to contain the value.