i can not find running sum in my properties box for access 2003

B

burkbank

i want each new record to be consecutively numbered starting with #1. when
trying to use the running sum function in properties, i have followed the
help section, but runningsum does not show up in the data tab, or under the
all tab.
everything else is there except runningsum.
 
G

Gina Whipp

Burkbank,

Sounds like you are on a form but since you didn't mention I can't be 100%
sure. RunningSum would apply to reports. OR are you in reports and having
a problem? More information needed!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index.htm
 
J

John W. Vinson

i want each new record to be consecutively numbered starting with #1. when
trying to use the running sum function in properties, i have followed the
help section, but runningsum does not show up in the data tab, or under the
all tab.
everything else is there except runningsum.
Click to expand...

Runningsum is a property of Textboxes on Reports - it certainly would not be a
property of a table or a form, and would not be appropriate for assigning
sequential numbers in any case!

Are you trying to do a "roll your own" autonumber, that is an editable but
sequentially assigned ID? If so you'll want to use some VBA code on a Form
(you can't do it in a Table).
 
Top