Entering numbers Incrementally

  • Thread starter Thread starter Ayo
  • Start date Start date
A

Ayo

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

Chris O'C via AccessMonster.com said:
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
Click to expand...
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Numeric increment 4
Get a number from a table to a form. 0
Simple Ref number for a form 2
How To Auto-Increment A Field In MS Access 2007? 4
Increment a number based on instances in another table 1
Access 2007 looses actual increment high value 4
Access 2003 vs. 2007 1
auto increment function missing in Access 2007? 5

Back
Top