Access Running Total on Form

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

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!!!!
 

OBP

Joined
Mar 8, 2005
Messages
19,896
ticklyfloss, this is a Major omission by Microsoft's design of Access, they have the running sum in Reports, but not Forms or for that matter Queries either.
It is simple enough to get the overall total using the "Sum" function, but when using a "Continuous Form" a text box will only show the overall total not the Running total for each record.
The attached database has 2 Queries in, one query adds the values in the records to give a running total and the the other subtracts the records from each other.
The SQL code fort the subtraction query was kindly supplied by Jimmy The Hand.
You should be able to modify the Adding Query to supply the data to your form, if you can't I can do it for you.
 

Attachments

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top