Multiple Field in an Event

[Emax]

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 with other two fields call DeCode, DPlace. pls help how can I program this in MS Access
Note: 7783457001 increment to 7783457050 (Maximum 10 Digits)

Thanks

[Rabbit]

You can use a For Loop with DoCmd.RunSQL but you don't actually mean to create fields right? You mean records?