hi everyone, is it possible to use the equivalent of IF statements in a query?
for example i might want one column in a query to be like:
=IF (t1.creditline < (t1.balance + t1.ordersbal)), "EXCEEDED LIMIT",)
which is saying 'show "EXCEEDED LIMIT" if BP balance plus doctotal is more than creditlimit'
can i do this?