Referencing an unbound text control in a footer

  • Thread starter Thread starter Gary.
  • Start date Start date
G

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
 
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.
 
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.
Click to expand...

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
 
Back
Top