<div>
That's probably the best way to do it, that is, calculating the values on the fly either on a report or form instead of storing them.
</div>


That's probably the best way to do it, that is, calculating the values on the fly either on a report or form instead of storing them.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I'm probably not able to do this with a calculated field but its worth a go.<br />
<br />
I'm trying to calculate fields on a subform and store this figure on the main form.
</div>
</div>


Hi,

I'm probably not able to do this with a calculated field but its worth a go.

I'm trying to calculate fields on a subform and store this figure on the main form.

DSum on calculated field in MS Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.