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.
Edward Pikman
Independent Consultant