hi,

Assume your table is called "MyTable", and the fields are called "area" and "days". Area can have values 1, 2 and 3;and every area have 3 days 1,2 and 3, i need 800 records from day 1 + 800 from day 2 and + 800 from day 3 for area 1,2 and 3

i mean i need exactly 2400 records(randomly). from evrey area
and deleted from "mytable" when i inserted to new table.

the total must be 7200 record at new table(table2)

thanks
m.qasem