UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Obtaining A List Of Sequential Numbers, Access 2016    
 
   
greggkastner
post Nov 11 2019, 02:18 PM
Post#1



Posts: 54
Joined: 24-June 07



I have a request from a co-worker to generate a list of sequential numbers based on a variable quantity.

There are a couple of other data points that will need to be captured while doing this. Those are: 1) name of requester, 2) date of request, and 3) project number. I would like to use the date and project number as primary keys in the table.

Example:
NAME OF REQUESTOR = Gregg Kastner
DATE OF REQUEST = 11/11/2019
PROJECT NUMBER = 135792
NUMBER OF SEQUENTIAL NUMBERS NEEDED = 150

What is the best way to do this in Access?

I’m currently using Access 2016.

Thanks
Gregg
Go to the top of the page
 
Larry Larsen
post Nov 11 2019, 02:40 PM
Post#2


UA Editor + Utterly Certified
Posts: 24,390
Joined: 26-August 02
From: Melton Mowbray,Leicestershire (U.K)


Hi Gregg

Are you saying you simply require (150) records from your above sample..??
thumbup.gif

--------------------
"Time...We have exactly the same number of hours per day that were given to Helen Keller, Pasteur, Michaelangelo, Mother Teresa, Leonardo da Vinci, Thomas Jefferson, and Albert Einstein"
H. Jackson Brown
Go to the top of the page
 
cheekybuddha
post Nov 11 2019, 02:53 PM
Post#3


UtterAccess Moderator
Posts: 11,910
Joined: 6-December 03
From: Telegraph Hill


Have a look at:

UA Wiki - Sequential Numbering

Custom Autonumbers


hth,

d

--------------------


Regards,

David Marten
Go to the top of the page
 
greggkastner
post Nov 11 2019, 05:36 PM
Post#4



Posts: 54
Joined: 24-June 07



Yes, in the example. But it can be as few as 10 and as many as several hundred at a time.

Thanks for asking,
Gregg
Go to the top of the page
 
RJD
post Nov 11 2019, 06:31 PM
Post#5


UtterAccess VIP
Posts: 10,153
Joined: 25-October 10
From: Gulf South USA


Hi Gregg: Just curious ... do you want the results saved to a table? If so, what other fields besides the ones shown will be required (to be filled in later)? Or do you just want a report listing that number of records (such as in the creation of "stickers" or file tabs, or even just a printed list)?

Attached is a way to create the records in a query, without saving them. If this looks promising, you can work it from there ...

HTH
Joe
Attached File(s)
Attached File  ProjectSequentialNumbers.zip ( 29.27K )Number of downloads: 4
 

--------------------
"Each problem that I solved became a rule, which served afterwards to solve other problems."
"You just keep pushing. You just keep pushing. I made every mistake that could be made. But I just kept pushing."

Rene Descartes 1596-1650 (Mathematician and Philosopher)
Go to the top of the page
 
Larry Larsen
post Nov 12 2019, 06:46 AM
Post#6


UA Editor + Utterly Certified
Posts: 24,390
Joined: 26-August 02
From: Melton Mowbray,Leicestershire (U.K)


Hi Gregg

I took went along the lines of simply looping and capturing the data into a table.

HTH's
thumbup.gif
Attached File(s)
Attached File  SeqNumber_UA.jpg ( 160.61K )Number of downloads: 6
 

--------------------
"Time...We have exactly the same number of hours per day that were given to Helen Keller, Pasteur, Michaelangelo, Mother Teresa, Leonardo da Vinci, Thomas Jefferson, and Albert Einstein"
H. Jackson Brown
Go to the top of the page
 
greggkastner
post Nov 14 2019, 09:04 AM
Post#7



Posts: 54
Joined: 24-June 07



Thanks RJD.

I will have some time this weekend to review this.

Your help is much appreciated.
G
Go to the top of the page
 
greggkastner
post Nov 14 2019, 09:06 AM
Post#8



Posts: 54
Joined: 24-June 07



Thanks Larry.

I will have some time this weekend to review this.

Your help is much appreciated.
G
Go to the top of the page
 
Jeff B.
post Nov 14 2019, 09:17 AM
Post#9


UtterAccess VIP
Posts: 10,336
Joined: 30-April 10
From: Pacific NorthWet


Not sure how I'd approach it from entirely within Access (but others have already offered ideas). I might just jump over to Excel, which can easily create sequential numbers, then import that spreadsheet into Access.

--------------------
Regards

Jeff Boyce
Microsoft Access MVP (2002-2015)

Mention of hardware or software is, in no way, an endorsement thereof. The FTC of the USA made this disclaimer necessary/possible.
Go to the top of the page
 
RJD
post Nov 14 2019, 08:44 PM
Post#10


UtterAccess VIP
Posts: 10,153
Joined: 25-October 10
From: Gulf South USA


Hi Jeff:
QUOTE
I might just jump over to Excel, which can easily create sequential numbers, then import that spreadsheet into Access.

Actually, that's what i did in my demo posted above. A one-time creation of a table called tblNumbers which is then used in all cases in a query to create the required records.

Regards,
Joe

--------------------
"Each problem that I solved became a rule, which served afterwards to solve other problems."
"You just keep pushing. You just keep pushing. I made every mistake that could be made. But I just kept pushing."

Rene Descartes 1596-1650 (Mathematician and Philosopher)
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    13th December 2019 - 03:52 AM