Crystal Reports How to Correct formula

Message


   i am using vb6 and sqlserver 2000
i made a formulal field and give theme a code 


Code: ( text )


(slaes.credit)-(sales.debit) +200

and then made a runnnig total of formula field
its work fine

but i know want not to add 200 to it but want to add the resulte
of the following querey

"select sum(credit) - sum( debit) where date < userinput"
or
in some reports i want the number which is is any form for this i use the following formula

(slaes.credit)-(sales.debit) + form1.text1.text 

but its shows an error

i want answer of how inseted of 200 we give number given by the query
and 
how to add number which is in form1.text1.text

how to solve this and 
thanks


Edited by muddasirmunir - 08 Nov 2007 at 7:27am