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

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.

-- 
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Gary." <gmhull@sbcglobal.net> wrote in message 
news:ubesP%23D8KHA.1424@TK2MSFTNGP04.phx.gbl...
>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" <NOSPAM_djsteele@NOSPAM_gmail.com> wrote in news:
#DsoBWE8KHA.1748@TK2MSFTNGP06.phx.gbl:

> 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