Can any body correct this formula

[muddasirmunir]

i am using vb6 and crystal report 10 with sqlserver 2000

i made a formulal field in crystal report 10 where i had a table
name sales , it has two numeric fields credit and debit and
give theme a code

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

in some report i want to add number from query and in some reports i want to add number from the textbox in form.

how to solve this
thanks

[Tequilaman]

Well, I guess you can correct the typo on your own...

[muddasirmunir]

what do you mean by this

Well, I guess you can correct the typo on your own...

[Tequilaman]

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

Sales.credit ....


I thought you would suddenly see that one when I remark it. I guess you didn't make the typo twice, so on the other side there is an object "sales.credit" not "slaes.credit"