dumb question

[flaviooooo]

Hey, this is probably a stupid question, but here it goes anyway:

I have following figures:

A B
0 10
2 12
4 11

Now I need to count the times a value bigger than 0 appears in column A and make a sum of all data in B

So I should get
A -2
B - 33

How can I achieve this? Do I need subreports etc or can I do it in the report?

 

[jrbarnett]

Hi,

Try

Select Count(A), Sum(b)
From table
Where a > 0
---
You may need to group by if you have anything else in the table or need to select something.

John


John Barnett

 

[CosmoKramer]

Summing field B is easy. Add a text box to your report footer and set its control source to:

=Sum([B])

To count the instances of field A:
Add an invisible text box to your detail section. Set its control source to:

=IIf([A]>0, 1, 0)

and set the Running Sum property to Over All.
Add a text box to your report footer to display the count. Set its control source to the name of the invisible text box you just added.

 

[danvlas]

Select Sum(Abs(Sgn([A]))) As CountNonZero, Sum() As TotalValues
From YourTable;

Good luck






Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html