Referencing an unbound text control in a footer

[Gary.]

I am trying to reference and unbound text control in the footer of a
report. I want to add it to the page footer

Report Name: repYearEnd
Footer name: GroupFooter0
Unbound text box: TotUnitPrice
=[Reports]![repYearEnd].[GroupFooter0].[TotUnitPrice]
Access can't find the text control
Can you tell me what I am doing wrong?

Thanks

 

[Douglas J. Steele]

Try just

=[Reports]![repYearEnd]![TotUnitPrice]

The fact that the control's in a footer should make no difference: all
controls on the report need to have unique names.

 

[Gary.]

Try just

=[Reports]![repYearEnd]![TotUnitPrice]

The fact that the control's in a footer should make no difference: all
controls on the report need to have unique names.

Thanks Mt Steele that was the answer I was looking for.

Is it possiable to run a sum total on a control in at footer? If so what do
I need to do