Link to home
Start Free TrialLog in
Avatar of leezac
leezac

asked on

Count months with exception

In the attached database is one table.  I need a way to count months (Date (Trade/Holdings)and subtract any months that are <1000 in the (total amt) column
but include the negative amounts
.
I have tried Not Like >=0 And <1000 but only shows negative number.

Thanks in advance.
db11.zip
ASKER CERTIFIED SOLUTION
Avatar of mbizup
mbizup
Flag of Kazakhstan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of leezac
leezac

ASKER

Thank you!