Solved

Microsoft Access Sum Query

Posted on 2009-05-10
1
957 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 250 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

840 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