I have the following data

Panel Form1 Form2 Form3 Form4 Totals (Wk)
A 10 1 0 6 17 1
B 0 2 5 5 8 10
C 1 2 3 5 6 12
----------------------------------------------------------
Totals 11 5 8 16 31

T (WK)>1 1 4 8 10 14

My question is how do I get the 2nd row of totals whereby i only want to add
the rows as where Wk > 1

JOM wrote:
>I have the following data
>
> Panel Form1 Form2 Form3 Form4 Totals (Wk)
> A 10 1 0 6 17
> 1
> B 0 2 5 5 8
> 10
> C 1 2 3 5 6
> 12 ----------------------------------------------------------
> Totals 11 5 8 16 31
>
> T (WK)>1 1 4 8 10 14
>
> My question is how do I get the 2nd row of totals whereby i only want
> to add the rows as where Wk > 1

Is this a database question or an Excel spreadsheet question?

Assuming it is a database question, I suggest that we will need to know
if you want to do with in a form, query or report? If you don't know, then
more information may help us help you.

--
Joseph Meehan

Dia duit

This is my report in Ms Access

"Joseph Meehan" wrote:

> JOM wrote:
> >I have the following data
> >
> > Panel Form1 Form2 Form3 Form4 Totals (Wk)
> > A 10 1 0 6 17
> > 1
> > B 0 2 5 5 8
> > 10
> > C 1 2 3 5 6
> > 12 ----------------------------------------------------------
> > Totals 11 5 8 16 31
> >
> > T (WK)>1 1 4 8 10 14
> >
> > My question is how do I get the 2nd row of totals whereby i only want
> > to add the rows as where Wk > 1
>
> Is this a database question or an Excel spreadsheet question?
>
> Assuming it is a database question, I suggest that we will need to know
> if you want to do with in a form, query or report? If you don't know, then
> more information may help us help you.
>
> --
> Joseph Meehan
>
> Dia duit
>
>
>

JOM wrote:
> This is my report in Ms Access
>
> "Joseph Meehan" wrote:
>
>> JOM wrote:
>> >I have the following data
>> >
>> > Panel Form1 Form2 Form3 Form4 Totals (Wk)
>> > A 10 1 0 6 17
>> > 1
>> > B 0 2 5 5 8
>> > 10
>> > C 1 2 3 5 6
>> > 12 ----------------------------------------------------------
>> > Totals 11 5 8 16 31
>> >
>> > T (WK)>1 1 4 8 10 14
>> >
>> > My question is how do I get the 2nd row of totals whereby i only
>> > want to add the rows as where Wk > 1
>>
>> Is this a database question or an Excel spreadsheet question?
>>
>> Assuming it is a database question, I suggest that we will need
>> to know if you want to do with in a form, query or report? If you
>> don't know, then more information may help us help you.
>>
>> --
>> Joseph Meehan
>>
>> Dia duit

I have not tried it out, but I would think that you would need to filter
the sum controls.

--
Joseph Meehan

Dia duit