<div>
On the sub datasheet footer create a control with the formula<br />
<br />
=Sum([Qty]*[Unit Cost])<br />
<br />
and another with the formula<br />
<br />
= Sum([Amount]*[Discount])<br />
<br />
Placing the control in the footer section will sum all the records in the detail section<br />

</div>


On the sub datasheet footer create a control with the formula

=Sum([Qty]*[Unit Cost])

and another with the formula

= Sum([Amount]*[Discount])

Placing the control in the footer section will sum all the records in the detail section


<div>
<div class="content wysiwyg-content">
I have a subdatasheet in a form. It is &nbsp;for parts used on an invoice.<br />
<br />
Qty &nbsp; &nbsp;PN &nbsp; &nbsp; Desc &nbsp; &nbsp; &nbsp;Unit cost &nbsp; &nbsp; &nbsp;Amount &nbsp; &nbsp; Discount &nbsp; &nbsp; &nbsp;Total<br />
<br />
Amount is = [Qty]*[Unit Cost]<br />
<br />
Total is = [Amount]*[Discount]<br />
<br />
There may be 5 or so parts that are used on an invoice.<br />
<br />
So there would be 5 values in the total column.<br />
<br />
How do I get the sum of these totals no matter how many rows there are?<br />
<br />
Any help would be greatly appreciated...<br />
<br />
Thanks...
</div>
</div>


I have a subdatasheet in a form. It is  for parts used on an invoice.

Qty    PN     Desc      Unit cost      Amount     Discount      Total

Amount is = [Qty]*[Unit Cost]

Total is = [Amount]*[Discount]

There may be 5 or so parts that are used on an invoice.

So there would be 5 values in the total column.

How do I get the sum of these totals no matter how many rows there are?

Any help would be greatly appreciated...

Thanks...

Sum the column in a subdatasheet.

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.