 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / May 2008Entering numbers Incrementally
Does Access have the increment function like in Excel where you can enter incrementing numbers in concecutive cells by dragging down, or across? No. The closest is the Autonumber data type - which is really a Long data type that can either increment to the next number for the next record or choose a random number for the next record. Chris Microsoft MVP >Does Access have the increment function like in Excel where you can enter >incrementing numbers in concecutive cells by dragging down, or across? Thanks Chris > No. The closest is the Autonumber data type - which is really a Long data > type that can either increment to the next number for the next record or [quoted text clipped - 5 lines] > >Does Access have the increment function like in Excel where you can enter > >incrementing numbers in concecutive cells by dragging down, or across? It's not the same as Excel. If you start entering a series going down the column, as you click in the next row, it will fill in 1 number. There is no dragging for a series of numbers.  SignatureArvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com > Does Access have the increment function like in Excel where you can enter > incrementing numbers in concecutive cells by dragging down, or across? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.