By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,652 Members | 1,911 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,652 IT Pros & Developers. It's quick & easy.

I need a repeating auto numbering field in a table

P: 3
I am an Excel user recently switching over to Access so this has been a learning curve. I have one primary table that has 3 variables one allows 4 entries before repeating, the next restarts at 12, and another at 18. In Excel this was a simple add one to the previous record. I've tried for days now to figure out a way to base my next record on the previous record value but I haven't been able to find a way. I have a basic understanding of Access and outside of this one function the program has been an awesome step up from Excel.
Dec 5 '16 #1

✓ answered by PhilOfWalton

I wonder if this might help


Share this Question
Share on Google+
4 Replies

Narender Sagar
P: 189
Your question is not clear enough to give any input
Please elaborate..
Dec 5 '16 #2

P: 3
I am working on a skydiving manifest database. My primary table for the [manifest] records the individual jumpers per load. We have 3 different aircraft we use that all have different amounts of jumpers the aircraft can take take. I select my aircraft from an [aircraft] table and using an iif scenario I populate a field of maximum allowable jumpers [SlotsAvail]. From there I would like to count the number of jumpers on the particular load and subtract that count from the available slots on the plane. I run everything through a split form. If possible I would like to automatically go to the next load number [LoadNum] when a load is full but if I do that I need an override as every load isn't filled to maximum capacity. My question is what is the best way to do this? Again I'm new to Access, in Excel this would be extremely simple. From what I have read about the only way would be through VBA or a sub query but I haven't figured out how to go about doing it yet.
Dec 6 '16 #3

Expert 100+
P: 1,430
I wonder if this might help

Dec 6 '16 #4

P: 3
Thank you, that makes great sense. I appreciate the help! If you ever decide to go skydiving in Florida come look me up!
Dec 7 '16 #5

Post your reply

Sign in to post your reply or Sign up for a free account.