Errors happen with totals

[Guest]

I needed two totals at the bottoms of two columns in a report, so I followed
the instructions from the posting "Total in a Report". I modified the form
that the report is based on, and put two text boxes in the footer section. It
worked great when I totalled the first column, but when I tried to do the
same thing for the second column, BOTH columns reported an error in the total
box.

One column is item dollar amt, the second column is the number of items. For
each column, I used:

=sum(["column name"])

for the control source. it worked fine when I did the dollar amt column, but
both columns errored out when I did the item number column. What could be
wrong?

 

[Guest]

I found the answer to my own question. It was a case of mislabled fields. It
works now.