twoyankeez
Thread Starter
- Joined
- Sep 20, 2002
- Messages
- 147
I am trying to build an expression in my Access report. It is a simple report with dollar amounts by each Donor. I want the expression to total the donation amounts. I have placed a text box from the control box in the footer and have gotten as far as building the expression. I have it total but when I view the sheet there is nothing there. I wrote the formula as: sum=[(sponsorship amounts)] I formatted the block as "Currency" because the first time I did it it totaled fine but did not appear with a dollar sign. When I changed it to Currency, NOTHING appeared. What am I doing wrong? Is there a simpler way to do this? 