I have an sql statement
If adRevCol is 0.00 it returns 0, if it is 10.00 it continues to return zero. If it is 16.66 it will return 1. Is this because I don't have proper formatting in the sql? Because I need it to return 1 as long as there is an amount greater than 0.00.Code:sum(iif(instr([yp_adv_data].[adRevCol],0),0,1))
Thanks for any help.