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.

Kelly