Is it possible to do a like search on a date field? So if the user types in 5, it will return all items where the month is may? Thanks.
Sure it is. I would suggest as a precaution to break up the date segments, just to be sure.<BR><BR>strSQL = "Select * from [table] where datepart(mm, [dateField]) = " & varMonthNumber