Hi Good day, I have a form with data and search box. I want to filter dates between 2 fields/textbox From and To. But this error appear as shown in the image below.
This is my SQL query . Thank you for the help.
This is my SQL query . Thank you for the help.
VBA Code:
sql = "select [Row Number],[ITEM],[NAME],[SO #],[DATE BILLED] from tblData " & _
" where [DATE BILLED] BETWEEN " & dtpFrom.Text & " AND " & dtpTo.Text & " " & _
" AND [SYS Payment Rcvd]='' order by [Row Number] DESC "