Access - Expression Builder problem

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

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? :confused:
 

etaf

Wayne
Moderator
Joined
Oct 2, 2003
Messages
65,468
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....
 
Joined
Aug 21, 2003
Messages
2,016
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
 

twoyankeez

Thread Starter
Joined
Sep 20, 2002
Messages
147
I actually entered it correctly, but reversed the formula when I typed it here. I tried removing the format and nothing appears still.
 

etaf

Wayne
Moderator
Joined
Oct 2, 2003
Messages
65,468
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
 
Joined
Aug 21, 2003
Messages
2,016
I don't think you need to have the word "sum" there.

If, in the textbox you just type in from the =, you should be okay.

MBN
 
Joined
Jun 17, 2002
Messages
2,556
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.
 
Joined
Jun 17, 2002
Messages
2,556
Go into "Sorting/Grouping" to activate your Footer for the Donor, and place the expression there.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top