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"

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.