-
query help
I am rather new to Access and I wanted to perform a couple of simply queries but I cant seem to figure them out.
Below is what I am trying to accomplish:
- Query 1: I need to take the product column and calculate the Total Taxes issued per product. The values for the 3 products are BB= $25, DD= $50, WC= $50. So I would want to build a query that will allow for me to indentify the product and then multiply it by its associated value.
- Query 2: I need to take the total taxes issued per product and then tie it to one of the site locations, either OH or UT. Then I need to find a total value of Taxes issued per site location. Then I have to calculate the sum of both sites.
Thanks for any help or feedback
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules