Results 1 to 2 of 2
2013-02-24, 12:54 #1
- Join Date
- Feb 2013
- Thanked 0 Times in 0 Posts
Access 2007, calculating total with tax from multiple entries
I'm trying to create a form (from the tables/queries) which will show a customers information (table 1), sale/invoice information (table 2), items sold (with each item sold being its on entry in its own row (table 3) then take the prices from table 3, add them together, and calculate the tax.
I have not been able to create a field in a query which takes information from different entries/rows (which are grouped together by the table 2 invoice number) and does the calculation.
Thanks in advance for the help!
2013-03-09, 10:33 #2
- Join Date
- Aug 2001
- Evergreen, CO, USA
- Thanked 65 Times in 64 Posts
Sorry - looks like your post got lost in the shuffle, so apologies for not responding sooner. In general you want to do calculations on the form you are using rather than trying to do them with queries - the exception is where a GroupBy query is used, but those are limited to doing sums an other functions such as Min or Max or Count. In forms you can do virtually any kind of math in a text box control, so you would typically create a sum of the prices and then multiply that sum by the tax rate to determine the amount of taxes. Alternatively, you could compute the tax on each item on the invoice, and then sum that field, but that tends to run into rounding problems.Wendell