the error i get back is "too few parameters... expected 2". but that's what i'm trying to pass.<BR><BR>dim objConn,objRS, begin, enddate<BR>begin = "01/01/2000"<BR>begin = CDate(begin)<BR>enddate = "04/01/200"<BR>enddate = CDate(enddate)<BR>Set objConn = Server.CreateObject("ADODB.Connection")<BR>objConn .ConnectionTimeout = 1000 <BR>objConn.Open "DSN=ACD"<BR>Set objRS = Server.CreateObject("ADODB.Recordset")<BR>SQL = "select * from 2_ACD_Data_by_Date WHERE [Forms]![Report 4]![txt_begining_dt] ='" & begin & "' AND [Forms]![Report 4]![txt_ending_dt]='" & enddate & "'"<BR> <BR> <BR>objRS.Open SQL, objConn<BR>
Should your Access query look like this:<BR><BR>"select * from 2_ACD_Data_by_Date WHERE begindate = [Forms]![Report 4]![txt_begining_dt] AND endDate = [Forms]![Report 4]![txt_ending_dt]"<BR><BR>You can't execute this query in ASP, and can't do anything with it with recordset object. If anything can be done, you have to use a command object to execute a stored procedure (your acess parameter query) with input parameters. I don't know if that can be done with Access although it is standard with SQL Server.