473,394 Members | 1,759 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,394 software developers and data experts.

calculation of running balance using a query

Hello Everyone,

Im a certified public accountant here in the Philippines. Im using microsoft access 2000 and 2003 running in a Windows XP environment.

Im having a problem of how to calculate a running balance using a query coming from two tables.

This is my problem. I have two tables (Sales and Collections), with these table I wanted to have a query to recalculate a running balance everytime there is a sales and collections transactions.

Thank you,

King
Mar 27 '08 #1
2 4006
Scott Price
1,384 Expert 1GB
Does
Expand|Select|Wrap|Line Numbers
  1. SELECT Sum(tblSales.Sales) As [SumOfSales] FROM tblSales
not work for you?

To make it recalculate whenever there is an additional Sales entry you just need to add a code line in the AfterUpdate event of whatever control is used to update the Sales figure:
Expand|Select|Wrap|Line Numbers
  1. DoCmd.Requery ("[QueryName]")
Regards,
Scott
Mar 30 '08 #2
Scott Price
1,384 Expert 1GB
This can also be done from within an unbound text box on your form where the totals are entered using something like this:
Expand|Select|Wrap|Line Numbers
  1. =Sum(DLookup("Sales", "tblSales"))
Regards,
Scott
Mar 30 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: paul | last post by:
I have a query that takes monthly totals and rolls them up to get a balance at a specific time code eg: dt bucket mon_ttl --- ------ ------- 199903 ...
1
by: Gx | last post by:
I have this form with the fields: * Product: (drop down combo box) with choices - X, Y * Amount: (currency ) * Balance (currency) I want to associate product X with the percentage...
5
by: bobdydd | last post by:
Hi Guys Can anyone help I am trying to find a way to implement a running balance that will re-calculate if the date order is changed, or if an earlier record is changed like you might want to do...
4
by: Rose | last post by:
A newbie question: I would like my repeater to look like the following where in the Balance column, I want to keep a running balance, like so Description Amount Balance Item 1 $10 ...
3
by: Marina | last post by:
I have a querie that needs to use multiple calculations (...I think...) Fields: TransID TransDate TransDescipt ClientID HoursBilled BillingRate
4
by: Jx4 | last post by:
I have a table with the account balance, a table with the account holders infomation, a table with the interest rate, and a table with the transactions. Then I start the queries to get some...
4
by: Jx4 | last post by:
Hi, I am creating a report for different accounts. I have a starting balance, and transactions. Everything is working great, however I am not able to create another column that can have the...
4
by: student2 | last post by:
Hi :-) I'm using Ms Access 2003 to create a DB for my school project and I need to accomplish the following:- * Calculate balances for stock (inclusive of sales and replenishment to stock) ...
2
by: sazd1 | last post by:
I am using vb express and MsAccess as database. I am trying to write a query for the calculation of Stock. My tables are as under: PId PDate ItemId Description Price Quantity ...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.