?
Solved

Microsoft Access Sum Query

Posted on 2009-05-10
1
Medium Priority
?
965 Views
Last Modified: 2012-08-13
I have a database that I have made with 4 different tables. In one table I have a blank cell of which I want to get the sum of 3 columns in the other tables.

I have no idea how the sql in access works so I'm basically stuck at the moment.

The column that is blank and needs the sum is:

Orders.Product_Build_Price


The 3 that I need to add up are as follows:

Product_PCB.PCB_Kit_Price
Product_Comp.Component_Kit_Price
Product_Pack.Packaging_Kit_Price


If you could help me do this then it would be much appreciated.
0
Comment
Question by:danthorpe2002
1 Comment
 
LVL 10

Accepted Solution

by:
Korbus earned 750 total points
ID: 24350343

You will want to use at least two queries:
one lookup query to sum up the values in the source tables
one update query to change the value in the destination table.
(You can use a query as the source table, for another query.)

You may even want to break the sum query into a few seperate queries.
One query for each table to sum up all thier values
Another query to add the results of each table sum together.

I suggest you play around with the graphical query designer in access a little bit, it's fairly intuitive.  I'd suggest you start with the three querys to sum up each table (PCB,Comp and Pack).
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question