A
Arash kamankesh
hi
i have a report with name "RPTsellfactor" with source "TBLorders"
ihave three txt box in it with name "TXTtotalprice","TXTcheque","TXTcash"
with currency format
i want to create a textbox with name "TXTremainder" that shows
"TXTtotalprice"-("TXTcheque"+"TXTcash") value
this report has been grouped by field "orderID" which is 'uniqe key' of
"TBLorders" on the
other word each page of this report showes one record of "TBLorders" and i
want to add
text box "TXTremainder" to it to show remainder currency of each order
i have tryed this formula [Total] - ( [Cash] + [Cheque] ) {total,cash &
cheque } are fields of table "TBLorders" but it doesnot works
please help me
thanks alot
i have a report with name "RPTsellfactor" with source "TBLorders"
ihave three txt box in it with name "TXTtotalprice","TXTcheque","TXTcash"
with currency format
i want to create a textbox with name "TXTremainder" that shows
"TXTtotalprice"-("TXTcheque"+"TXTcash") value
this report has been grouped by field "orderID" which is 'uniqe key' of
"TBLorders" on the
other word each page of this report showes one record of "TBLorders" and i
want to add
text box "TXTremainder" to it to show remainder currency of each order
i have tryed this formula [Total] - ( [Cash] + [Cheque] ) {total,cash &
cheque } are fields of table "TBLorders" but it doesnot works
please help me
thanks alot