Hi gurus i am using visual basic 6.0 and access 2000. I have table like 1 5 10 20 100 500 1000 i have to generate this table data to another table 2000 or 20000 how many records i want. second table look likes 1 5 10 20 100 500 10 20 1 500 1000 100 ..... ..... generate 200 or 2000 or 20000 how many records i want. please help me thanks in advance. kickkat