[glass90land]

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

MS Access 2003 Window XP home

[OBP]

Where in Access are you doing these calculations?

[glass90land]

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

[OBP]

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]

Thanks for your interest, but I have erased the non-working boxes and used a query and it works now

Cheers Paul

[MRdNk]

Please mark thread as Solved.