Query to round sum one for one and one to many

[GCLIFTON]

How would you write this in sql to get the same results. I have one data dump
'



=IF(ROUND(SUMIFS([Amount],[Financial Complex],[@[Financial Complex]]),2)=0,"Zero")

=IF(AND(ROUND(SUMIFS([Amount],[Financial Complex],[@[Financial Complex]]),2)>-5,ROUND(SUMIFS([Amount],[Financial Complex],[@[Financial Complex]]),2)<0),"Less 5",IF(AND(ROUND(SUMIFS([Amount],[Financial Complex],[@[Financial Complex]]),2)>0,ROUND(SUMIFS([Amount],[Financial Complex],[@[Financial Complex]]),2)<5),"between zero and 5","Not between -5 and 5"))

[ranman256]

just build a normal query, then right click the field, and set the format([field],2)

or ROUND([field])