Thanks to those that helped me with my question earlier.<BR><BR>I am setting up a search on six fields. How do I write select statements that will search all six fields to create the record set? And, how do I set my statement so that if one of the criteria is left blank (like last name) it will search on all the data in that field?<BR><BR>Thanks in advance for your help.<BR><BR>Chris