By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,121 Members | 1,782 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,121 IT Pros & Developers. It's quick & easy.

VBA, Access, and multiple value column

P: 1
I'm just trying a order management system. I have a tax table with fields taxid, taxcode and tax so that tax rates can be changed in the future. I have a combo box in the order details form that enables users to select 2 or more tax rates. The issue now is how to get the values from the tax table to calculate the total tax and finally used it to calculate the total cost. How do I achieve this
Nov 30 '17 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,494
You can have calculated fields in queries and use aggregate functions (Sum(); Avg(); Max() etc) in reports.
Dec 1 '17 #2

Post your reply

Sign in to post your reply or Sign up for a free account.