little help

[leburg]

I have a select statement:

SELECT number, SUM(paid1) AS dar_total
FROM dbo.payhistory
WHERE (batchtype = 'DAR')
GROUP BY number

What my new spec requires that I excluded any paid1 < .02 prior to including it in the 'sum' of them all.

All help greatly appreciated and many thanks in advance!

 

[gmmastros]

SELECT number, SUM(paid1) AS dar_total
FROM   dbo.payhistory
WHERE  batchtype = 'DAR'
       And Paid1 >= 0.02
GROUP BY number

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[r937]

george, for crying out loud, where are your parentheses, man!!

;-)

[small]and how come all your keywords are in caps except for "And"[/small]

r937.com | rudy.ca