Can anyone please look at this and tell me where my problem is. I can not seem to be able to find the answer. I am using Access 2000 on win 2000 prof. I get this error:<BR>Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)<BR>[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.<BR><BR>The error is comming from my WHERE clause (When I remove it I get no error), I have replaced the variable mvar with now() in the WHERE caluse and it works just fine, messages.Date is a date field. Is there something I'm missing with the date translation? Any help would be most appreciated.<BR><BR>mvar = formatDateTime("10/19/2000 12:00:01 PM")<BR>myDSN = "msgbrd"<BR>mySQL = "SELECT messages.ThreadID" ' Numeric field<BR>mySQL = mySQL & ", threads.ThreadHeader" 'Text Field<BR>mySQL = mySQL & ", threads.numPosts"<BR>mySQL = mySQL & ", count(*) as NewRecs"<BR>mySQL = mySQL & " FROM messages LEFT JOIN threads ON messages.ThreadID = threads.ThreadID"<BR>mySQL = mySQL & " WHERE messages.Date < mvar"<BR>mySQL = mySQL & " GROUP by Messages.ThreadID, threads.ThreadHeader, threads.numPosts"