theak47

let's explain ideahave one field autonuber just to count... and this table will have more than that 2000 numberseach number is presenting a year 0 - 2007...each number + G is presenting relationship primary key... so i know what year im usingthats the point

yes, that is good idea, and i now just wondering what the code will be for fill 2000 numbers from 1 to 2000

This aint web based.Im just using database from Access and im wondering if here is way to fill it without typing values on keyboard, that will realy help me out!

Hello I have one questionI have simple table in Access 2003 with three fieldsOne is (field name), type - autonumberone is (field name), type - numberone is (field name), type - textmy problem is that i need in number field nubers between1 and 2000 and in text fields same numbers between 1 and 2000 with letter G at the end.that will look likeAutonumber 1 ... 574 ... 2000Number 1 ... 574 ... 2000Text 1G ... 574G ... 2000GProblem is that I dont know how to write a code for that i think that there would be a macro.So can someone help me please!