Just want to ask if there's a way to search in a date/time field in access and display only the month that match the string from a textbox. The query below.
sql = "SELECT * FROM tblName WHERE fldDate LIKE '%" & textbox1.text & "%'"
So if I typed in "ma" from the textbox, it will display all the months with "ma" on it (e.g. March, May)