Solved

Sum field from multiple records

Posted on 1998-10-30
1
122 Views
Last Modified: 2010-04-30
Is there a way to add one field from a database.
Ex. The field Ending_Balance. Adding this field from every record for a grand total into another field. Using SQL I can not find a way. Is there another way.
0
Comment
Question by:robhas
1 Comment
 
LVL 1

Accepted Solution

by:
lawnranger earned 20 total points
ID: 1442620
USE an SQL Aggregate function (SUM in this case) as in;

SELECT SUM(Ending_Balance) AS Total_Balance FROM YourTable WHERE Month=6
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

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

773 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