I am trying it add to this select statement so that I can pull information about this account manager between a date range. I can not seem to figure out how to run multply searchs from one select statement. <BR>Any help would be greatly appreciated. <BR>I am using the varibles SearchDate1 and SearchDate2<BR><BR>Set recordSet=Server.CreateObject("ADODB.Recordset")<B R>recordSet.Open "SELECT * FROM [MEDICAL QUOTE] WHERE [ACCOUNT MANAGER] = &#039;"& SearchInfo &"&#039; ", connectionToDatabase,1,2<BR>