Calculating field values

  • Thread starter Thread starter Mark Carlyle via AccessMonster.com
  • Start date Start date
M

Mark Carlyle via AccessMonster.com

ok I have a table that looks something like this

date credit debit balance account number
1/1/05 25 55
1/5/05 10 55
1/6/05 18 56
1/10/05 15 56


What I need to do is populate the running balace based on date and account
number

I can do it kinda with double click and calculating; however, it only steps
in the order it was imported. What I want to do is be able to run a process
that will just sort by account number then date and then populate the running
balance

output should look something like this

date credit debit balance account number
1/1/05 25 25 55
1/5/05 10 15 55
1/6/05 18 18 56
1/10/05 15 3 56

Thanks in advance for the help.
 
Mark:

The following KB article may be useful in designing a running sum query.

http://support.microsoft.com/default.aspx?scid=kb;en-us;290136

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


message ok I have a table that looks something like this

date credit debit balance account number
1/1/05 25 55
1/5/05 10 55
1/6/05 18 56
1/10/05 15 56


What I need to do is populate the running balace based on date and account
number

I can do it kinda with double click and calculating; however, it only steps
in the order it was imported. What I want to do is be able to run a process
that will just sort by account number then date and then populate the
running
balance

output should look something like this

date credit debit balance account number
1/1/05 25 25 55
1/5/05 10 15 55
1/6/05 18 18 56
1/10/05 15 3 56

Thanks in advance for the help.
 
Ok I have printed and worked with these 2 examples for hours now... I can get
a total of the Credit and Debit fields... but it will not do a running total.

The problem I am seeing is that the running total examples are giving a
running total for every item in the query.

I want to only total by trust account numbers

the final expression for the running total is what I am having difficulty
with.

In my Query I made a column to create line total. This sums the difference
between the credit and deposit.

I cannot find a way to make the DSum work though

I think a large part of my problem is poor understanding of the DSUM syntax.

Any additional help would be greatly appriciated.
 
Back
Top