Hi I am trying to create report that can search in database for sertain informaion. I have Database souce in Access which has linked table to Oracle dababase. that's only thing i can have access to so have no other choice to go direct Oracle database! I have following similiar query to have report select dt.test_Name, dt1.address,dt.zip, dt1.contactinfo from deadtable dt join deadtable1 dt1 on dt.test_nbr = dt1.test_nbr where dt.test_name like ? --> this is the parameter i am trying to use to pass information in. is there a better way that i can use please advise. Thanks Thanks!!