first off separate presentation from the data
don't push string representations of numeric data around, disdpaly them using froamt where required
the logic [qiote]a.) blank if nothing's been paid on the invoice
b.) dollar amount that is balance due (in currency format)
c.) $0.00 if it's paid in full (in currency format)[/quote] seems flaky to me
either their is a balance on the account or there isn't so option 1 doesn't make sense to me.
the third option is usually returning a balance if its outstanding. ie should have received payment by now. and one way of doing that is to say change the display. if you have access to colour printers then they are a good way to go. however a surefire technique is to say change the background (ive often used a dark background with pale letters to indicate this sort of issue and its printer independant). however if you are sendingthe document to a custoemr by pdf or other electronic means then colour considerations change.
and what is the value of where after you have built this clause
again its impossible to tell what is going on without seeing the actual value of the SQL being passed to the SQL engine
I'd rather be riding on the Tiger 800 or the Norton