422,751 Members | 2,137 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 422,751 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


NeoPa
Expert Mod 15k+
P: 30,740
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.