I want to total a column on my report per page but when I put my expression in the page footer it gives me a error. Is it possible to do this in the page footer? I tried using a group footer but then it breaks my data apart. Any suggestions

Try this Microsoft Support article: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q132017

HTH,
David R