<div>
<div class="content wysiwyg-content">
what it wrong in this method that i try to use in acces vba (to make a the round the total before tax to make that the toal with the tax (that is there 0.16 precent) will be a round number:<br />
Private Sub RoundThePrice()<br />
Dim d<br />
d = sum(Forms!invoicet!invoice<wbr />detailst.F<wbr />orm!Total * 1.16 - Round(Forms!invoicet!invoi<wbr />cedetailst<wbr />.Form!Tota<wbr />l * 1.16, 0) / 1.16)<br />
<br />
End Sub<br />
<br />
but a get a compile error :<br />
Sub or Function not defined
</div>
</div>


what it wrong in this method that i try to use in acces vba (to make a the round the total before tax to make that the toal with the tax (that is there 0.16 precent) will be a round number:
Private Sub RoundThePrice()
Dim d
d = sum(Forms!invoicet!invoicedetailst.Form!Total * 1.16 - Round(Forms!invoicet!invoicedetailst.Form!Total * 1.16, 0) / 1.16)

End Sub

but a get a compile error :
Sub or Function not defined

a problem in a sum function in vba access 2010

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.