Addition Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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.
 
This is my report in Ms Access

Joseph Meehan said:
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.
 
Back
Top