getting a field to display

[cj_steve]

Hello,

I have a report whose record source is a query that contains 3 tables, with one of the fields named SUM.

Basically these are invoices and at the end of the report I want to print the value of the field SUM. In the Page Footer I have a text box whose value is:

=IIF([Page]=[Pages],[SUM],"")

The last page prints #ERROR for the value of SUM. I'm not quite sure what I am doing wrong. Any help would be much appreciated.

Thank you

 

[cj_steve]

Ahhhhh, got it. I changed the name of the text field and it worked the value name and the text name were the same.

Thank you!!!