Originally Posted by DataMiser If the fields are date type in the mdb then you must use # signs around them in MS Access Code: SQL = "select R1, R2 from " & bname & " where DT1 between #" & CStr(DateBegin) & "# and #" & CStr(DateOver) & "# order by DT1 asc" Thank you. I got it.
SQL = "select R1, R2 from " & bname & " where DT1 between #" & CStr(DateBegin) & "# and #" & CStr(DateOver) & "# order by DT1 asc"
Forum Rules
Re: how to read data from two date time?
Originally Posted by DataMiser
Reply With Quote
