Number fields? (1 Viewer)

[disgruntled]

i asked this question earlier about doing a SQL Insert but not working when fields left empty. I was refered to change all the "Required" and "allowzerolength". Thanks, it worked great with a table holding all text. However i have another table with all numbers. These dont have the allowzerolength property and all the "Requireds" are set to "NO"

 

[Howlsta]

Maybe you are having problems because the values are null, do you wamt to change them to zero? You can build a query based on the table that converts nulls to zero

eg TotalCost: NZ([Parts]) +NZ([Time])

NZ determines whether the field has a null value and converts it to zero.