DSum #Error

L

Linda

I have a report that is grouped by Appropriation and then by Source. I have
a subtotal at the end of each source section within the Appropriation. I
have Appropriation header, source header, detail, source footer, page footer,
and report footer. I would like to put a grand total in the report footer
for each Source. I have a text box for each of the two sources. In the text
box control source I have the following statement: =DSum("
[Recon-Allow-FRSACR]![amount] "," [Recon-Allow-FRSACR]![amount] ","
[Recon-Allow-FRSACR]![source] ='ACR'") I am getting #Error on the
report. Any suggestions? I had this working before but then had to revise
the original table and now I get the #Error.
 
K

Ken Snell [MVP]

What is [Recon-Allow-FRSACR]![amount] and [Recon-Allow-FRSACR] ? If
[Recon-Allow-FRSACR] is the report on which you're putting this result, this
won't work.

If [Recon-Allow-FRSACR] is a table, then try this:

=DSum("[amount]","[Recon-Allow-FRSACR]","[source] ='ACR'")
 
L

Linda

That was it. Thanks.

Ken Snell said:
What is [Recon-Allow-FRSACR]![amount] and [Recon-Allow-FRSACR] ? If
[Recon-Allow-FRSACR] is the report on which you're putting this result, this
won't work.

If [Recon-Allow-FRSACR] is a table, then try this:

=DSum("[amount]","[Recon-Allow-FRSACR]","[source] ='ACR'")

--

Ken Snell
<MS ACCESS MVP>

Linda said:
I have a report that is grouped by Appropriation and then by Source. I
have
a subtotal at the end of each source section within the Appropriation. I
have Appropriation header, source header, detail, source footer, page
footer,
and report footer. I would like to put a grand total in the report footer
for each Source. I have a text box for each of the two sources. In the
text
box control source I have the following statement: =DSum("
[Recon-Allow-FRSACR]![amount] "," [Recon-Allow-FRSACR]![amount] ","
[Recon-Allow-FRSACR]![source] ='ACR'") I am getting #Error on the
report. Any suggestions? I had this working before but then had to
revise
the original table and now I get the #Error.
Click to expand...
Click to expand...
 
Top