473,387 Members | 1,497 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Automatically create records between two numbers

Hi

I'm pretty new to creating databases, I am having trouble trying to work out how to auto fill between two numbers.

I would like to be able to enter (via a form) a starting number such as 4358 and an ending number 4378 and have Access automatically create the numbers in between as records in my samples table.

Any help with this would be greatly appreciated.
TIA
Aug 12 '16 #1
1 791
PhilOfWalton
1,430 Expert 1GB
So are you trying to add 21 records to a table, starting at 4358 and ending at 4378?
Anything before 4358, anything to come after 4378?
Any other data to go with those records?
Are they to be created instantly in one go, or over a period of time as other information is added?

Phil
Aug 12 '16 #2

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

Similar topics

1
by: Lauren Quantrell | last post by:
I have a temp table that's populated with an insert query in as tored procedure. The temp table has a uniqueID as the primary key. In that table I have a column SortOrder. What I want to do is to...
11
by: Matt | last post by:
Hi everyone, still pretty new to MySQL. I was wondering if there is a way to automatically filter records based on a mysql userlogin name?? I have serveral databases that I want to combine in...
3
by: Mark | last post by:
Hi all, What I am trying to achieve is for a user to enter a colleague identification number into field . Then they are to add the first date of holiday into field . Finally they are to add the...
1
by: md7546 | last post by:
Hi, first time posting to this group, but I have followed advice and examples for several months, so thank you. I work for a small telecommunications company. I have a simple Orders database...
0
by: neoteny2 | last post by:
I need MS Access to automatically create reports/subreports based on specific criteria. I am building a database in Access 2003 with different locations/sites. I have the "sites" table created...
1
by: needin4mation | last post by:
I want to use the Menu and SiteMapPath. But it looks like I have the create the xml file that stores the data by hand. What if I had a site with 500 pages? That seems to be to cumbersome. Is...
2
by: roadworrier | last post by:
I'm trying to create a new object to use as an associative array automatically. I can programmatically create new variables like this: for (var i; i < 10; i++) { window; window = "moo" +...
1
by: scrapamy | last post by:
I'm using Access 2003 and have looked through this forum and found a few topics that are quite close but haven't given me the answer I need. I have one form with just two fields (number & name)...
2
by: bmcgree1 | last post by:
Here is my problem. I have a lot of different fields that all revolve around two date fields, BeginDate and EndDate. The user enters information into both these fields along with other data. My...
3
by: Sunigahj | last post by:
I have a form with a sub form that is loaded by code. Everything works except the main form ID does not appear on the subform. When new records are added manually everything works fine. All...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.