I need some help with the syntax required to return data between user specified dates.
txtFrom and txtTo are user input text boxes where only date formats are allowed.
adoChart.RecordSource = "SELECT * FROM History WHERE (Date) BETWEEN ' & txtFrom & ' AND ' & txtTo & ' AND Investor_Number = " & frmStartPage.txtHoldInvestorNumber & " Order By Date DESC"
adoChart.Refresh
Thanks,
Dwight
txtFrom and txtTo are user input text boxes where only date formats are allowed.
adoChart.RecordSource = "SELECT * FROM History WHERE (Date) BETWEEN ' & txtFrom & ' AND ' & txtTo & ' AND Investor_Number = " & frmStartPage.txtHoldInvestorNumber & " Order By Date DESC"
adoChart.Refresh
Thanks,
Dwight