ticklyfloss
Thread Starter
- Joined
- Mar 23, 2005
- Messages
- 48
I have a form with a subform..... the main form shows me the client information (name, address, tel no etc), the subform lists all the orders made for that particular customer.
On the sub form, I want it to perform a running total next to each order, e.g.
Order ID Order Amount Balance
123 £25.00 £25.00
124 £50.00 £75.00
125 £50.00 £125.00
I can do this in a report, but I can't get it to work on a form..... I must be using the wrong calculation.
Any help would be appreciated!!!!
On the sub form, I want it to perform a running total next to each order, e.g.
Order ID Order Amount Balance
123 £25.00 £25.00
124 £50.00 £75.00
125 £50.00 £125.00
I can do this in a report, but I can't get it to work on a form..... I must be using the wrong calculation.
Any help would be appreciated!!!!