Help with Calculated Fields

[Jaci]

I have a very simple database that I am creating to capture purchase order information. My fields are basic info such as customer, job number, vendor, etc. Then I have created fields Quanity1, ItemDesc1, Price1, Total1. I have created 8 records in this format with the Total1 field being a calculated field of Quantity1*Price1. I have also created a Grand total field that will add all the calculated Total1-8 fields. I have created a form for data entry that will also be printed at the time of entry to create a hard copy for filing in the job. Currently the Grand Total field will only work if all of the Total fields have data otherwise the Grand Total is blank. There are many cases where we will only order 1 item and I would still like the grand total to be displayed at the bottom of the form. Currently my Grand Total field is total1 + total2 + total3 etc. Can anyone help?

[burrina]

You need to use the Nz Function. Here is an example.

Something = Nz(Sum([Payment]),0)

HTH