I tried this query statement in VBA but in return no record.
Dim dtDate1 As Date
Dim dtDate2 As Date
dtDate1 = Trim(Me.txtClosing1)
dtDate2 = Trim(Me.txtClosing2)
Set rs1 = dbs.OpenRecordset("SELECT * FROM PRP160 WHERE trim([transport co])='" & Trim(Me.cmbTransporter) & "'" _
& " and ([eff date]>= " & dtDate1 & " and [eff date]<=" & dtDate2 & ")")
[eff date] is in datetime MS access format.
This thing really made me confuse, as i see no reason for it to return 0 record. Please advice if you find anything wrong with my query.