Hello. I have a database that will have the following scenario: a form will check to see if a record exists in a table as part of a calculation nz(dsum function). When no record exists yet (and this will happen) I was getting an error. I have built a workaround with a trigger. The trigger creates a record with a zero amount to be used in the calculation. Later I would delete the zero record, but this seems ridiculous. My questions is: what other options should I be looking at, what is a better practice when no record exists and you are including it in a calculation? Looking for ideas here... Thanks.