Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 780
  • Last Modified:

a problem in a sum function in vba access 2010

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
0
bill201
Asked:
bill201
1 Solution
 
Farzad AkbarnejadCommented:
Hello,
Access haven't sum function in vba module code
Why you want to use Sum?

-FA
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now