If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
counting specific entries
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] |
#3
|
|||
|
|||
counting specific entries
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] |
#4
|
|||
|
|||
counting specific entries
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)) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
counting date entries by month & year | Di | Worksheet Functions | 7 | August 24th, 2005 08:39 PM |
Counting unique entries of numbers and text | Excel Needy | General Discussion | 1 | June 26th, 2004 01:46 AM |
Counting Cells that contain Specific text | G Kennedy | Worksheet Functions | 2 | June 10th, 2004 03:01 PM |
Counting number of certain entries | Holly Cetron | Running & Setting Up Queries | 2 | June 9th, 2004 12:46 AM |
counting specific words | jim | Worksheet Functions | 5 | March 3rd, 2004 02:52 PM |