Help with Totals in Report

[Kissi5559]

Hello,
I need help in calculating the total of a field. I have a field [xfer/order]
which contains ("O" or "T"). Another field [TOTAL LINES] contains numeric total
lines for "O" and "T". I want to calculate total lines for all [xfer/order] =
"O" and same for "T".

This how I want my report to look.

TOTAL LINES FOR "O" = ******
TOTAL LINES FOR "T" = *******

Where ****** is what I want to calculate.

I tried this but didn't work: Sum([TOTAL LINE](IIF([xfer/order] = "O",1,0)))

[Mark A. Stacklin]

Why not just use a query as the control source propery of your text box.

Select Sum([xfer/order]) from [Tablename] where [xfer/order] = 'O'

And check for a T in a sql statement for the other text control and your done.

You could also create an access query on the query tab and choose it using the
expression builder. That would end up having the same result as well.

Keep things simple.
Hope this helps you

Kissi5559 wrote:

Hello,
I need help in calculating the total of a field. I have a field [xfer/order]
which contains ("O" or "T"). Another field [TOTAL LINES] contains numeric total
lines for "O" and "T". I want to calculate total lines for all [xfer/order] =
"O" and same for "T".

This how I want my report to look.

TOTAL LINES FOR "O" = ******
TOTAL LINES FOR "T" = *******

Where ****** is what I want to calculate.

I tried this but didn't work: Sum([TOTAL LINE](IIF([xfer/order] = "O",1,0)))

[Kissi5559]

Hi,
I tried it but it didn't work, it gives me a syntax error. I want the sum of
[TOTAL LINES] when [xfer/order]="O"

Thanks.