How do I do that?
I've used the following code
but nothing shows on the data report.Code:openDB poproDB.Open "SELECT * FROM trans WHERE status = '" & "finished" & "' AND (podate >= #" & Format(DTPicker1.Value, "mm/dd/yyyy") & "# AND podate <= #" & Format(DTPicker2.Value, "mm/dd/yyyy") & "#)" Set rptReports.DataSource = poproDB rptReports.Show




Reply With Quote