need help Access query

Results 1 to 2 of 2

Thread: need help Access query

  1. #1
    sunny Guest

    Default need help Access query

    am trying to create an application in which i have to retrieve data (if exists) from access database, between two dates. one date is the current system date and one is a date calculated by asp. i need to know how to pass the date calculated by ASP.

  2. #2
    sunny Guest

    Default need help Access query

    Am using the following query and getting an error as below:<BR>strSQL = "SELECT tblTimeInfo.UserName, tblTimeInfo.ProjectCode, tblTimeInfo.wDate, tblTimeInfo.HrsWorked, tblTimeInfo.WorkDone<BR>FROM (tblEmpInfo INNER JOIN tblEmpPass ON tblEmpInfo.UserName = tblEmpPass.UserName) INNER JOIN tblTimeInfo ON tblEmpPass.UserName = tblTimeInfo.UserName<BR>WHERE (((tblTimeInfo.UserName)=[tblEmpPass].[UserName]) AND ((tblTimeInfo.wDate)=#" &strtDate &"#));"<BR><BR>Error:<BR>Error Type:<BR>Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)<BR>[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.<BR>/temp/ret time info.asp, line 92<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts