trying to create query that only sums data greater than 0 1

[Buddha1]

I am trying to create a query that sums data greater than zero example:

Blue cross month1 month2 month3 month4
-120.00 50.00 300.00 500.00
450.00 45.00 65.00 -45.00
78.00 -15.00 15.00 35.00

I only want to add values that are greater than 0.00 I don't want to add the negative balance. I would like to keep it in the column format like above so for example column4 total should read 535.00.

 

[SteveR77]

In your query design set up a select query with the criteria of > 0, then change the query to a group by query.

This change can be made by clicking on the Sigma button (It looks like a stylized upper case E). This will give you a group by line in your query, change that option for group by to sum and you should have what you are looking for.


HTH,

Steve