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()
d = sum(Forms!invoicet!invoicedetailst.Form!Total * 1.16 - Round(Forms!invoicet!invoicedetailst.Form!Total * 1.16, 0) / 1.16)
but a get a compile error :
Sub or Function not defined
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.