Need help on expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query which includes a field for the dollar amount of payments made
by check. I want to have that field totaled. I created a text box in the
footer of the report, as Access suggests I do, but I can't seem to get the
formula right. This is what I have now:

=[Sum]([Check Amount])

["Check Amount" is the field name]

But this just comes up with no total, but no error message either.

Any ideas?

I'm working in Access 2002/Win XP Pro
 
Putting something in brackets indicates it is a field name. You don't have
a field called "sum". Try:

=Sum([CheckAmount])
 
Duh, stupid me I think I knew that at one point (about the brackets), but I
was trying everything under the sun to try to make it work!

At any rate, I tried your suggestion and I get the same thing....there is no
error message, but the field comes up blank on the report. Any other ideas?
It seems like this should be so simple, I know I'm missing something easy and
obvious.

Rick B said:
Putting something in brackets indicates it is a field name. You don't have
a field called "sum". Try:

=Sum([CheckAmount])


--
Rick B



NAF_SPAC said:
I have a query which includes a field for the dollar amount of payments made
by check. I want to have that field totaled. I created a text box in the
footer of the report, as Access suggests I do, but I can't seem to get the
formula right. This is what I have now:

=[Sum]([Check Amount])

["Check Amount" is the field name]

But this just comes up with no total, but no error message either.

Any ideas?

I'm working in Access 2002/Win XP Pro
Click to expand...
Click to expand...
 
You said you put this in the Footer of the report.

Did you put it in the Report Footer or the Page Footer? If the latter, then
this will not work.

If the former, do you have a field named "CheckAmount"? Is the field in the
reports record source (the query or table)?



NAF_SPAC said:
Duh, stupid me I think I knew that at one point (about the brackets), but I
was trying everything under the sun to try to make it work!

At any rate, I tried your suggestion and I get the same thing....there is no
error message, but the field comes up blank on the report. Any other ideas?
It seems like this should be so simple, I know I'm missing something easy and
obvious.

Rick B said:
Putting something in brackets indicates it is a field name. You don't have
a field called "sum". Try:

=Sum([CheckAmount])


--
Rick B



NAF_SPAC said:
I have a query which includes a field for the dollar amount of payments made
by check. I want to have that field totaled. I created a text box in the
footer of the report, as Access suggests I do, but I can't seem to get the
formula right. This is what I have now:

=[Sum]([Check Amount])

["Check Amount" is the field name]

But this just comes up with no total, but no error message either.

Any ideas?

I'm working in Access 2002/Win XP Pro
Click to expand...
Click to expand...
Click to expand...
 
Ah, that did it! The devil is in the details, right? I didn't pay close
enough attention to see which footer the expression should go in. Thank you
so much - I think you saved my sanity! It's working perfectly now. :)

John Spencer (MVP) said:
You said you put this in the Footer of the report.

Did you put it in the Report Footer or the Page Footer? If the latter, then
this will not work.

If the former, do you have a field named "CheckAmount"? Is the field in the
reports record source (the query or table)?



NAF_SPAC said:
Duh, stupid me I think I knew that at one point (about the brackets), but I
was trying everything under the sun to try to make it work!

At any rate, I tried your suggestion and I get the same thing....there is no
error message, but the field comes up blank on the report. Any other ideas?
It seems like this should be so simple, I know I'm missing something easy and
obvious.

Rick B said:
Putting something in brackets indicates it is a field name. You don't have
a field called "sum". Try:

=Sum([CheckAmount])


--
Rick B



I have a query which includes a field for the dollar amount of payments
made
by check. I want to have that field totaled. I created a text box in the
footer of the report, as Access suggests I do, but I can't seem to get the
formula right. This is what I have now:

=[Sum]([Check Amount])

["Check Amount" is the field name]

But this just comes up with no total, but no error message either.

Any ideas?

I'm working in Access 2002/Win XP Pro
Click to expand...
Click to expand...
Click to expand...
 
Back
Top