counting specific entries

here is my info....
report with detail
2 Footers
1 page footer
1 report footer
the 2 footers create lines like this;
4066 5 E 282 $253.80
4066 4 L 2061 $1854.90
4066 2343 $2108.70
4067 3 E 457 $411.30
4067 5 L 2195 $1975.50
4067 2652 $2386.80

I need a way to total in the report footer the totals from the E's and a
total from the L's. If i try to just create a textbox with =Sum ( [text61] )
on the Report Footer, i always get prompted for text61 value on the start of
the report being run.
Thanks

ld-runner wrote:

here is my info....
report with detail
2 Footers
1 page footer
1 report footer
the 2 footers create lines like this;
4066 5 E 282 $253.80
4066 4 L 2061 $1854.90
4066 2343 $2108.70
4067 3 E 457 $411.30
4067 5 L 2195 $1975.50
4067 2652 $2386.80

I need a way to total in the report footer the totals from the E's and a
total from the L's. If i try to just create a textbox with =Sum ( [text61] )
on the Report Footer, i always get prompted for text61 value on the start of
the report being run.


The aggregate fnctions only operate on **fields** in the
form/report's record source table/query, so that's why you
are having a problem with that.

I think the Report Footer text box can use expressions like:

=Sum(IIf(xxx = "L", amount, 0))

--
Marsh
MVP [MS Access]

thanks, my solution was this...
=Sum(Abs([loaded]="E")*[pay_distance])
and
=Sum(Abs([loaded]="L")*[pay_distance])

"Marshall Barton" wrote:

ld-runner wrote:

here is my info....
report with detail
2 Footers
1 page footer
1 report footer
the 2 footers create lines like this;
4066 5 E 282 $253.80
4066 4 L 2061 $1854.90
4066 2343 $2108.70
4067 3 E 457 $411.30
4067 5 L 2195 $1975.50
4067 2652 $2386.80

I need a way to total in the report footer the totals from the E's and a
total from the L's. If i try to just create a textbox with =Sum ( [text61] )
on the Report Footer, i always get prompted for text61 value on the start of
the report being run.


The aggregate fnctions only operate on **fields** in the
form/report's record source table/query, so that's why you
are having a problem with that.

I think the Report Footer text box can use expressions like:

=Sum(IIf(xxx = "L", amount, 0))

--
Marsh
MVP [MS Access]

That's a little more obscure than the one I posted.
However, they are equivalent so it's your call.

I do have to wonder why you posted the question when you
already had an answer or was it the case that you found an
answer after you posted and forgot to close out your thread?
--
Marsh
MVP [MS Access]


ld-runner wrote:
thanks, my solution was this...
=Sum(Abs([loaded]="E")*[pay_distance])
and
=Sum(Abs([loaded]="L")*[pay_distance])


ld-runner wrote:
here is my info....
report with detail
2 Footers
1 page footer
1 report footer
the 2 footers create lines like this;
4066 5 E 282 $253.80
4066 4 L 2061 $1854.90
4066 2343 $2108.70
4067 3 E 457 $411.30
4067 5 L 2195 $1975.50
4067 2652 $2386.80

I need a way to total in the report footer the totals from the E's and a
total from the L's. If i try to just create a textbox with =Sum ( [text61] )
on the Report Footer, i always get prompted for text61 value on the start of
the report being run.


"Marshall Barton" wrote:
The aggregate fnctions only operate on **fields** in the
form/report's record source table/query, so that's why you
are having a problem with that.

I think the Report Footer text box can use expressions like:

=Sum(IIf(xxx = "L", amount, 0))