Referencing a report footer total in the page or report header

[rocketman70443]

Hopefully this will be my last hurdle.

My report has a text box with the follwing properties:
Name: Sum of PRICE Grand Total Sum
Control Source: =Sum([Sum Of PRICE])

I'd like for this same total to appear in the page header. If that's not possible my boss will have to settle for the report header. I've been experiementing with control source, but no luck yet. Please help asap!!

 

[rocketman70443]

Solved my own issue. I just had to play with the expression builder a bit more. Instead of trying to build my own expression, I just kept selecting every sum that appeared in the report expression builder until I found one that worked.

 

[boblarson]

I'm downtown.

What does the row source for your combo box 46 look like (by the way it is good to name them with good names ASAP so you don't spend your time writing for that non-descript name and then want to change it to be descriptive. I would suggest making sure that most of your controls (labels maybe not so much) are renamed to something easily identified instead of just the numbering that comes out by default when you add a new control.