I would like to sum a series of fields on my Form but for some reason if there is not a value in one of the fields it will not sum any of them. What can I do to get it to sum even if all the fields do not have values? Thanks!

Any sums that include nulls will produce a null answer so use Nz() the null to zero function on each of the fields in the equation.

Use the NZ function. This will convert a null value to zero and let you generate the total.

=nz(field1) + nz(field2) + nz(field3)

HTH