Stuart has attended:
Access Intermediate course
Access Advanced course
Access VBA course
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.
RE: Access
Hi Stuart,
Thank you for the forum question.
If you open the table in design view and set the field property "Default Value" to 0 for the fields, then Access will for each new client automatically add the 0.
I hope this will solve the problem.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
