help on running balance

[ai_enjoi via AccessMonster.com]

i have two columns on a query,..receipts and disbursements,,both in currency
type..is there any expression that i can use to compute for the running
balances for every entry on either fields like say:

Rcpt....Dis....RunningBal
1000....0.......1000
..0...(500)......500


thank u...

 

[Guest]

Your data has no item number or date so you can't create a running balance.
You must have a field or fields that identify the exact order of the records.
If you have such a field, please reply with your exact table and significant
field names.

 

[ai_enjoi]

actually, i have the field names IndexNum, AcctTitle, RcptAmnt, DisbursedAmnt on the table tblTransDetail

 

[ai_enjoi via AccessMonster.com]

the table is tblTransDetail with field names:

IndexNum, Date, PayeeID, SpecificAcct, RcptAmnt, DisAmnt...

i want to create a query that would compute the running balance for each
Payee...
this i will use for the individual accounts of each payee..

Your data has no item number or date so you can't create a running balance.
You must have a field or fields that identify the exact order of the records.
If you have such a field, please reply with your exact table and significant
field names.

i have two columns on a query,..receipts and disbursements,,both in currency
type..is there any expression that i can use to compute for the running

[quoted text clipped - 5 lines]

thank u...

 

[Guest]

What field identifies the order?
As an example from the Northwind Orders table. If I want to get a running
sum of the Freight by CustomerID in order of the OrderID, I would use this
SQL:

SELECT Orders.CustomerID, Orders.OrderID, Orders.Freight,
(SELECT Sum(Freight) FROM Orders O
WHERE O.CustomerID = Orders.CustomerID and O.OrderID<=Orders.OrderID)
AS RunningFreightBalance
FROM Orders
ORDER BY Orders.CustomerID, Orders.OrderID;
--
Duane Hookom
Microsoft Access MVP

the table is tblTransDetail with field names:

IndexNum, Date, PayeeID, SpecificAcct, RcptAmnt, DisAmnt...

i want to create a query that would compute the running balance for each
Payee...
this i will use for the individual accounts of each payee..

Your data has no item number or date so you can't create a running balance.
You must have a field or fields that identify the exact order of the records.
If you have such a field, please reply with your exact table and significant
field names.

i have two columns on a query,..receipts and disbursements,,both in currency
type..is there any expression that i can use to compute for the running

[quoted text clipped - 5 lines]

thank u...