Recent content by Joe1991

Thanks for the prompt reply.. I am trying to create a Access Form which looks like this: Date --- Description --- Debit --- Credit --- Balance --- Net 12/03/2011 --- Cash --- -£10 --- £0 --- -£10 --- -£10 13/03/2011 --- Deposit --- £0 --- £20 --- £10 --- £20 14/03/2011 --- Deposit --- £0 ---...

Hi, I'm after a form which looks like this: Balance Previous Balance 0 0 1 0 2 1 3 2 4 3 I need a column which returns the previous value from the previous record. I have tried using Dlookup but it fails. Is there anyway I can do...

Timf79, Goh's suggestion returns something like this: Date Description Debit Credit Net Balance 13/03/2011 Cash -10.00 0 -10.00 0 14/03/2011 Deposit 0 10.00 10.00 0 But I need it to look like this: Date Description Debit Credit Net Balance 13/03/2011 Cash -10.00 0 -10.00 -10.00...

Timf79, Goh's suggestion returns something like this: Date Description Debit Credit Net Balance 13/03/2011 Cash -10.00 0 -10.00 0 14/03/2011 Deposit 0 10.00 10.00 0 But I need it to look like this: Date Description Debit Credit Net Balance 13/03/2011 Cash -10.00 0 -10.00 -10.00...

Thanks for both of your replies. Goh - I have tried your suggestion but I would like a running cumulative balance after each record. I would appreciate any further suggestions!

Hi, I am trying to create a Form which would display the following columns: Date, Description of transaction, Debit, Credit, Net, Balance. For example: Date Description Debit Credit Net Balance 18/08/2010 Cash Withdrawal -£10.00 £0.00...