hi..
i created a function in my main program called rate()
like this

function rate()
lparameter dialednr,code,result,result,n
select rates $$ my rates table
set order to tag code $$code is field that contains the country areacodes
seek left(view1.dialednr,6) &&dialednr is the fieldname of the calls in view
for n=1 to fcount()
if field(n)=upper(code)
return eval(field(n))*result &&result is the result of the duration
endif
endfor
rate=n
return rate
endfunc

the question is is this function selecting the right field for the rates if customer has rate 2....?
THANK YOU FOR YOUR HELP..













>>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.