Results 1 to 2 of 2
  1. #1
    New Lounger
    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!

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Evergreen, CO, USA
    Thanked 58 Times in 58 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.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts