Hi - I have a query that contains a number field for inventory quantities. When I run the query it populates appropriately where stock exists and leaves it null if there is no stock. I need to have zeros in the places where there is no stock. So, I created a new field and put in this string to place the zeros in the blank spaces. WK1: NZ([WK],0) This worked great, it gave both the inventory quantities and zeros where there was no stock. The problem is that the field is automatically a text field and I cannot tell it how many decimal places. Right now it shows multiple places. If it was a number field, I could do it but not in a text field. I tried to change it in the report and was unable also. I am assuming I should change the string I put in to get the zeros but I do not know what to change it to.