i have a query
[Total]/[times paying]
this will give me how much i should churge him every period of time
the best way of writing it is like this
[total]-[paid]/[times paying]-[times paid]
the problem is when finelly he paid everything then
you'll be dividing by zero, and thats returns error
how could i avoid this problem
i gess it should be something like this iif([times paying]-[times paid]),0,?????
i am very new to the sql statments
[Total]/[times paying]
this will give me how much i should churge him every period of time
the best way of writing it is like this
[total]-[paid]/[times paying]-[times paid]
the problem is when finelly he paid everything then
you'll be dividing by zero, and thats returns error
how could i avoid this problem
i gess it should be something like this iif([times paying]-[times paid]),0,?????
i am very new to the sql statments