I want to SQL example Jan 3th and Dec 18th. Were the Month is a field and the date is a field. Here how I trying to do it
a,b,c,d are given by user where d = Dec, b = jan, c = 18 and a = 3
Dim sql14 As String
sql14 = "Select * from days where month between '" & d & "' and '" & b & "' and DAte between '" & c & "' and '" & a & "'"
Set db = OpenDatabase(txtPath)
Set dbs = db.OpenRecordset(sql14)
Set Data2.Recordset = dbs
dbs.Close
db.Close