Field Generating

[MRuzly]

Dear Friends

I want to creat more than one field in table on one event.
example:

staring mobile no: 7783457001
end mobile no: 7783457050

if enter starting and end mobile numbers in text box and click save button. database shuld create fields between 7783457001 and 7783457050 and save mobile numbers in table field. pls help how can I program this in MS Access Form with MS SQL.

Note: 7783457001 increment to 7783457050 ( Maximum 10 Digits)

Thanks

[debasisdas]

As you have posted a question in the articles section it is being moved to SQL Server forum.

MODERATOR

[ck9663]

As you have posted a question in the articles section it is being moved to SQL Server forum.

MODERATOR

this should be easy for the experts...i would think this is just a counter and a loop. one thing to watch out for, if this is the starting numberL: 7783457001 and your counter reach millions you might end up with something like 7790000somethin g. if this is a mobile number and 779 is area code, this would mean the phone number will start with zero, i don't think this is a valid one...