hi all,
i have a table with more than 87000 records,
i have fields(clintno),telno,customer name,....&& not index
i need to to know how many tel.lines for every clint and replace the numbers i count to field(count1) for every tel.line,and replace the count again at another field(count2) as...
first index mytable via clint_no.
client_no tel.no name count1 total
1 111 aa 5 0
1 221 aa 5 0
1 332 aa 5 0
1 444 aa 5 0
1 555 aa 5 5
2 3321 vvv 7 0
2 3214 vvv 7 0
2 6254 vvv 7 0
2 7894 vvv 7 0
2 6287 vvv 7 0
2 2364 vvv 7 0
2 9687 vvv 7 7
3 . . . .
. . . . .
.
.
thanks.
m.qasem