Hey all,<BR><BR>I am writing a qry into a Access DB that had the date field as a text field. I want to just filter by month. Here is what I have.<BR><BR>Dim db, sorter, strsql, conn, sumqry, objQuery, totalcalls, totaltime, average<BR>Dim m, strdate<BR>strdate = now()<BR>m = Month(strdate)<BR>if m &#060; 10 then<BR> m = "0" & m<BR>End if<BR>response.write(m)<BR>db = Request("p")<BR>set conn = server.CreateObject("ADODB.Connection")<BR>set rs = server.CreateObject("ADODB.Recordset")<BR>conn.Pro vider = "Microsoft.Jet.OLEDB.4.0"<BR>conn.ConnectionSt ring = Server.MapPath(db&"db
ecords.mdb")<BR>conn.open<BR>strsql = "SELECT Avg(Record.duration) AS AvgOfduration, Count(Record.date) AS CountOfdate FROM Record where (((Record.date)=Left(2," & m & ")))"<BR>set rs = conn.Execute (strsql)<BR>set totalcalls = rs("CountOfDate")<BR>set average = rs("AvgOfDuration")<BR><BR>My problem is that the months 09 and below actually end up querying as 9 instead of 09. any ideas how I can pass this as 09 not 9.<BR><BR>Thanks