I am trying to grab specific data from a db.. I am trying to grab a single field that meets two other fields criteria.. Here is my SELECT:<BR><BR>"SELECT Desc FROM pics WHERE RO_Num = " & lngRO_Num & " AND Pic = " & lngPicID<BR><BR>I cannot get past this part.. I cant get anything to pull from the lngPicID for the table.. Can anyone help me with this statment? First off is it correct Syntax?? Second I have an If then statement to give the lngPicID a value.. So it shouldnt have problems finding the lngPicID value, and lngRO_Num has a value.. Anyone have any suggestions?