Access

Hi,

I have 2 tables and 2 forms with a bit of a mix of information on each which works exactly as we need them.

However, I have recently added a "Total Owing" field to a table which adds historical data e.g

Charge09 Paid09 Charge10 Paid10 and so on up to date.
300 300 300 300

I have the total owing on one of my forms and the breakdown on the 'back form'. So far so good!

The problem comes when we use the form to add a new client - if we don't manually type "0" in the fields (Charge09 Paid09 etc) the form cant calculate the total owing for the current year.

When we add a new client how do we get those fields to automatically populate the blanks with a "0"?

Thanks,

Stuart

PS
The field data type is £currency.