Home > IT Answers > Microsoft Windows > How to enter a field with number increments in Access 2007
SatbirBlog
15 pts.
 How to enter a field with number increments in Access 2007
Access 2007, Access 2007 forms, Access 2007 functions
How to increment a number field adding 3 with the number from the same field of the previous record. (like entering next invoice number)

Software/Hardware used:
Access 2007
ASKED: August 2, 2010  10:01 PM
UPDATED: August 6, 2010  5:22 PM
RELATED QUESTIONS
Answer Wiki:
if this field is going to increment with the same unit then try to make that field as auto increment field in database.
Last Wiki Answer Submitted:  August 3, 2010  5:07 am  by  NetDeveloper   90 pts.
All Answer Wiki Contributors:  NetDeveloper   90 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Auto increment field increments with 1 only, question is how to increment with 3, specially when the initial number is not 1 but lets say number 2000

SatbirBlog
 15 pts.
 

You can do it in SQL:

create table T (id counter(2000,3), f1 char(5));
msi77
 1,610 pts.