If your using an ADO recordset for the reports datasource then use something like this
Code:
select * from table1 inner join table2 on table1.paymentId=table2.paymentId where table1.paymentId='" & Text1.Text & "'"
If your using a DataEnvironment for the datasource then check out this post
http://www.vbforums.com/showthread.php?t=552148