Count months with exception

leezac used Ask the Experts™
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.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2013
I think this is what you are looking for - if you want to include large negative numbers in the records you are filtering out:

SELECT Count(Date.Month) AS CountOfMonth
FROM [Date]
WHERE  Abs([TotalAmt])<1000;

Open in new window


Thank you!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial