By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,390 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 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,186
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.