Solved: MsAccess Running Sum

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.

glass90land

Thread Starter
Joined
Oct 5, 2008
Messages
6
First how can I easily display tabular data in this forum

I am trying to build a database to record my climbing exploits. I want to keep a running sum of pitches and lengths like in the attachment (relevant data only shown - figures in brackets = what I get)


To do the running totals I have used running sum fields as follows

Num led by me Iif([led by]="me",1,0)
This works

length Iif([led by]="me",[length],0)
This does not work, the running sum is not kept as can be seen above.

If I change the field value (length), for a constant eg 6, a running sum is kept, If I just put in length as the source (without the Iif statement) it does not work. It just puts the value and not the running sum

What is going on please? Its driving me crackers :mad:

MS Access 2003 Window XP home
 

Attachments

glass90land

Thread Starter
Joined
Oct 5, 2008
Messages
6
I am doing the calculations in a report text box, following the example on the MSAccess help pages. Actually I have done it another way now, but would still like to know what is going on - Thanks:rolleyes:
 

OBP

Joined
Mar 8, 2005
Messages
19,895
Can you post a zipped copy of the database, less any "personal" data as an attachment.
It would be best if you Compact & repair it first to reduce it's size.
If we can't get the iif statements to work I can create you some simple VBA code to do it.
 

glass90land

Thread Starter
Joined
Oct 5, 2008
Messages
6
Thanks for your interest, but I have erased the non-working boxes and used a query and it works now

Cheers Paul:)
 
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