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

Generate records based on a given number range

P: n/a
I am an access newbie and I have the following question.

Say, There is a text box in a form for input a number range and
the user inputs the following.

TextBox: AA123453,57-59,500,505-507,556

I wish to add the following 9 records to the table.

AA123453
AA123457
AA123458
AA123459
AA123500
AA123505
AA123506
AA123507
AA123556

This saves time for the user when there are lots of such numbers
to be input for e.g. 505-550, etc.

Could someone tell me how I might go about in doing this?
Is programming the only option? and if yes, how?

Anyone else had to use such a feature in their db. How did you
go about implementing it?

Thanks.
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.