Auto fill a table?

[newtoAccess]

Is there a was to auto fill a table? Eg: I am looking for a way to create 200 records from 001 to 200. Just a count from 1 to 200. With out typing them in manualy.

[NTC]

a vb loop of an insert query would work...probably by the time you figured out how to write it out it would simply be easier to type it b.t.w. there is no way to have 001 in a number field....it will drop those leading 00s....

[newtoAccess]

I changed the field to text and manually filled the table using 001, 002 etc

Thanks

[Rainlover]

Although you can't store a Number of 001 you can display it like that using a Format of 000.

But do this in your Form rather than the Table