>Now how do i put the results into another text box somthing like this but it gives me a syntex error
>local setdate1 setdate2
>setdate1 = thisform.text1.value
>setdate2 = thisform.text3.value
>
>SELECT SUM(Inv.soldprice);
> FROM pawn!Inv;
> WHERE Inv.solddate BETWEEN setdate1 AND setdate2 ;
> into thisform.text2.value <<< this probably not right.
>
The target for a SQL SELECT must be a table, cursor or array; you can do something like the following instead:
SELECT 0
USE pawn!Inv AGAIN ALIAS (SYS(2015))
SUM soldprice TO thisform.text2.value FOR BETWEEN(solddate,setdate1,setdate2)
USE