• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 968
  • Last Modified:

Microsoft Access Sum Query

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:


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


If you could help me do this then it would be much appreciated.
1 Solution

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).
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now