troubleshooting Question

How to create incremeneted Check Number in Access table from a specified starting check number.

Avatar of Anthony6890
Anthony6890 asked on
Microsoft Access
11 Comments1 Solution96 ViewsLast Modified:
Hi, I'm trying to create a module or some type of formula that will prompt the user to enter a beginning check number:  i.e. 1118172 and then update subsequent rows in a table with sequential number including that first number, incremented by 1 for each subsequent line.  

Here is an example...

Starting Check Number:  1118712
First three rows in the table would have:


I have a column in a table labeled:  RFCK#.  I would like to use some form of a parameter value to enter the first check number and then cascade down, as I described above.  I've tried many things, but it is just getting frustrating.

Any help on this would be greatly appreciated.

Join our community to see this answer!
Unlock 1 Answer and 11 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros