Mar 15 2007, 11:53 AM
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?
Mar 15 2007, 11:57 AM
Set the control Source to =1 and the running sum to yes. The set the format property to 000.
Mar 15 2007, 12:07 PM
This works. But, oddly enough when I try to concatenate this field with another field, it just removes those beginning zeros!
Mar 15 2007, 12:20 PM
You need to carry the format into the concatenate expression as well.
Mar 15 2007, 12:25 PM
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.
Mar 15 2007, 12:52 PM
Is the control source for your new text field: =Format([RunSum],"000") & [OtherFieldName]
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here