Assuming your using SQL Server 2000 (if not you could do something similar but using stored procedures)<BR><BR>I'd create a function and use that.

This is a pain when trying to display the amounts on a VB form and having to reformat .00 to 0.00.<BR>I am thinking of just using null and >0 values instead of allowing a zero value. <BR><BR>So ...