What are you trying to do? The thread title is unclear, I do not understand your last word - what did you mean?

>hi all,
>i need your help, to compute the Percentaje to all teams for evry area alone,
>and how many records i can take from evry team to compleat 100%
>and 100% mean 150 records only from evrey area
>ex..
>team 112=10% mean 20 record
>team 113=5% mean 10 record
>. . .
>. . .
>. . .
> 100% 150 records
>and when i get the result for evrey team i want to multiplay *4,
>ex..
>team 112( 20 record*4)
>team 113( 10 record*4)
>.
>.
>.
>
>
>and replace all (randomly)records i get to new table, and deleted from the source table,... next area.
>
>thanks
>m.qasem