Hello:
I have a table that has several currency fields (for the cost of products, employee fees, etc.). For some of the fields, when the value is zero, $0.00 is shown in the field, however in other fields when the value is zero, the field is just blank. This creates a problem when running calculations in a query as the blank fields do not calculate. I've made sure that the properties of all fields are exactly the same. I've tried setting the default value to no avail.
Anyone have a clue as to why this is happening and how to correct it?
Thanks,
I have a table that has several currency fields (for the cost of products, employee fees, etc.). For some of the fields, when the value is zero, $0.00 is shown in the field, however in other fields when the value is zero, the field is just blank. This creates a problem when running calculations in a query as the blank fields do not calculate. I've made sure that the properties of all fields are exactly the same. I've tried setting the default value to no avail.
Anyone have a clue as to why this is happening and how to correct it?
Thanks,
