UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Running Sum in Report    
 
   
estee
post Mar 15 2007, 11:53 AM
Post #1

UtterAccess Addict
Posts: 106
Hi all,

I would like to have a text box thats a running sum in a report. But I would like to start it with 001 instead of 1. It will continue for each record, 002,003, and so forth. Is this possible?

Thanks you!
Estee
Go to the top of the page
 
+
dashiellx2000
post Mar 15 2007, 11:57 AM
Post #2

UtterAccess VIP
Posts: 9,209
From: Maryland
Yes.

Set the control Source to =1 and the running sum to yes. The set the format property to 000.

HTH.
Go to the top of the page
 
+
estee
post Mar 15 2007, 12:07 PM
Post #3

UtterAccess Addict
Posts: 106
This works. But, oddly enough when I try to concatenate this field with another field, it just removes those beginning zeros!
Go to the top of the page
 
+
dashiellx2000
post Mar 15 2007, 12:20 PM
Post #4

UtterAccess VIP
Posts: 9,209
From: Maryland
You need to carry the format into the concatenate expression as well.
Go to the top of the page
 
+
estee
post Mar 15 2007, 12:25 PM
Post #5

UtterAccess Addict
Posts: 106
The concatenated field is: A text field that is always the same thing, and this running sum field. I tried formatting the 001 in the contcatenated field too, stil doesnt work.
Thanks
Go to the top of the page
 
+
dashiellx2000
post Mar 15 2007, 12:52 PM
Post #6

UtterAccess VIP
Posts: 9,209
From: Maryland
Is the control source for your new text field: =Format([RunSum],"000") & [OtherFieldName]
Go to the top of the page
 
+
« Next Oldest · Access Q and A · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th June 2013 - 09:23 PM