hi ,

i do it,it give a error message(sql:invalid top specification)
when =messagebox(m.lnNumberToExtract)&& THE RESULT IS 0

 =messagebox(m.lnNumberToExtract)&& THE RESULT IS 0
 =messagebox("Vartype " + vartype(m.lnNumberToExtract))&&this is ok the result is N

i try to put this statment under, it works but the count at temp table less than the choises records from mytable,

if lnNumberToExtract<>0 or if lnNumberToExtract >0
if m.lnNumberToExtract<curPercentage.TeamCount
.
.
endif
endif

thanks.
m.qasem