thank you for your hel...i'm sorry i'm very new to fox..
whta exactly is that function doing..?
its taking the code from the rate tabel and ordering it
and then its taking the firs 6 digits form where(? is ccallnumber)








>lparameter cCallNumber,cRateselected,nLengthofcall
>select rates
>set order to tag code
>seek left(cCallnumber,6)
>for n=1 to fcount()
> if field(n)=upper(cRateselected)
> return eval(field(n))*nLengthofcall
> endif
>endfor
>
>>edwared thank you very much..
>>maybe you cna help me with another problem.
>>i need to detrmine the rate per call that a customer has..
>>in my customer screen i the enduser preset the rate like: rate3
>>
>>my table of rates goes something like this
>>
>>code country rate_1 rate_2 rate_3 rate_n
>>011575 Colombia .23 .22 .21 .28
>>nrecords nrecords
>>
>>if john doe has a preset rate of rate_1 and he made calls to 011575832469 this means that he is going to get biled at .21 cents times the ammount of minutes he spoke...
>>
>>which one is the best way of figuring this pizzle im doing this for three days allready
>>the key to it would be to let the program know to choose the rate from the field that matches the rate
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>>>whhen i do report form myreport.frx to preview it gives me the preview onlty for the first record and its information...
>>>>what do i need to do in order to get all the records one after the other like billing
>>>
>>>You should get all records on preview. Do you put report fields into detail band? Also make sure that table is open in active work area.