Running Total in Access 2002

[rocafella_solider]

Hello,

I'm creating a tenant database and am trying to get a running total of
what people owe. I want a running total per person. The running total
seems to work but the total are all one row down.
After I can get the running total to work I want to print a report
based on the tenant with all the transaction for a select time spand. I
have no idea how to get that working so any help on wither problem will
be great. Thanks

Table is Rent Fields are ID, Name, Transaction Type, Date, amount
Query is Total
Fields in query are ID, Name, Transaction Type, date, amount
This is how

This is what it looks like

ID Name Date Transaction Type Amount Balance
1 JH 9/10/05 lANDSCAPING Fee (50) Blank
1 JH 9/11/05 Landscaping Paid 50 ($50.00)
1 JH 12/1/05 Rent Charged (450.00) $0.00
1 JH 12/10/05 Rent Received 450.00 ($450.00)
1 JH 10/1/05 Repairs (50) $0.00
2 CL 10/1/05 Deposit Charged (300.00) Blank
2 CL 10/10/05 Deposit Rcvd 300.00 ($300.00)
2 CL 10/15/05 Repairs (50.00) $0.00
2 CL 11/1/05 Rent Charged (300.00) ($50.00)

This is what i whould like it to look like

ID Name Date Transaction Type Amount Balance
1 JH 9/10/05 lANDSCAPING Fee (50) ($50.00)
1 JH 9/11/05 Landscaping Paid 50 $0.00
1 JH 12/1/05 Rent Charged (450.00) ($450.00)
1 JH 12/10/05 Rent Received 450.00 $0.00
1 JH 10/1/05 Repairs (50) ($50.00)
2 CL 10/1/05 Deposit Charged (300.00) ($300.00)
2 CL 10/10/05 Deposit Rcvd 300.00 $0.00
2 CL 10/15/05 Repairs (50.00) ($50.00)
2 CL 11/1/05 Rent Charged (300.00) ($350.00)

I have taken an Access 2002 class about 2 yrs ago so know how to use
it. I also know the basic in SQL.

 

[rocafella_solider]

I forgot to put this in.

This is how I'm getting the Balance
Balance: (SELECT Sum([MONEY])
FROM RENT f
WHERE f.ID=RENT.ID
AND f.Date < RENT.Date)

 

[Larry Linson]

Consider doing a Report, putting in transaction amount twice and using the
Running Sum property of the second occurrence. I think that may give you the
result you desire.

Larry Linson
Microsoft Access MVP