draw lines in report

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top