Tech Support Guy banner
Status
Not open for further replies.
1 - 9 of 9 Posts

·
Registered
Joined
·
147 Posts
Discussion Starter · #1 ·
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? :confused:
 

·
Super Moderator
Joined
·
65,526 Posts
try taking the format off again and see if it works OK - just in case something else has changed. Then at least you know ots the format fuction....
 

·
Registered
Joined
·
2,016 Posts
You were close. Type =([sponsorship amounts]) - please note the placement of parens and brackets...yours were reversed.

This assumes that the "sponsorship amounts" field is the one that is attached to each donor in the detail of the report.

MBN
 

·
Super Moderator
Joined
·
65,526 Posts
so you said in your post - it worked before you formated, but did not display properly - so what else did you change, other than the format
 

·
Registered
Joined
·
2,556 Posts
Which "Footer" are you working in? The Page or the Report Footer?

You can't calculate in the Page footer, but you can get the value to appear by referring to it from elseware.
 
1 - 9 of 9 Posts
Status
Not open for further replies.
Top