I'm not sure which 150 records you want and what are criterias to choose them.

>thank you very much,
>
>it works,
>
>i need your help to complate this code,
>
>i need to compute how many records i can get for evrey team Percentaje ,
>and from every area i need just 150 records from all teams,
>ex..
>

>areacode  team  no.of records Percentaje  records* Percentaje  team.total
>1         112       250        65.32%      result?              result *4
>.          .         .          .           .                     .
>.          .         .          .           .                     .
>.          .         .          .           .                     .
>                                            150 records           600 records
>-----------------
>next area
>2          .
>.
>

>after that i need to insert all records(randomly) i get it, to new table
>
>and deleted from table1.
>
>i know it is to much ,but very defcult for me.
>
>thanks,
>best regards.
>m.qasem