troubleshooting Question

Sum only positive values in ACCESS 2003 table

Avatar of Sandra Smith
Sandra SmithFlag for United States of America asked on
Microsoft AccessMicrosoft Development
11 Comments3 Solutions355 ViewsLast Modified:
I have a table with fifteen columns that need to be summed for a report.  There are about 150 rows BUT I only want to sum the positive values.  That is, say TotalApp column has 145 rows with a positive value, but five with a negative.  Is there an easy way to tell the query to only sum the 145 posuitive values and ignore the negative?  I know I can do an If statemnt in the format of Iif(TotalApp <0, 0, TotalApp) but I really do not want to have to do this for all fifteen columns as this is eventually going to be run from a code module and not the query pane.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 3 Answers and 11 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros