Running total

[Susan Jayne]

Hi, I have just been reading the past few days and found an item that answers my question - in a round about way - by adding a 'Save Record' button I can update the Expense Totals field by clicking on the button.

If anyone has a better idea I would still be interested.

This will teach me to read before posting! Sorry.

Susan

 

[joeyreyma]

if your expense totals field is physically saved in your table and it is a calculated field then i think your on the wrong track. calculated fields are not suppose to be saved with your details. better have it displayed on the forms only, don't bother saving it.

 

[Susan Jayne]

Hi Joey

Thanks for your reply, 'expense totals' is a calculated field on my main form, not saved, it just updates the calculation when you click on the 'Save Record' button.

In fact I think I've cracked this database, at last. Just need to run it in parallel with the spreadsheet for a while to find any bugs. I think - I will be back - as someone famous used to say!