Solved

Microsoft Access Sum Query

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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.

810 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