Hi. I am trying to produce some reports in the Data Report in VB6. What i need to do is this,
I have 2 text boxes on my form (txtDate1.Text and txtDate2.text) and a Command Button. i want to enter a start date and End date, and a Report will be printed out with the data that falls into that criteria. I have only just found out about Data Reports and am very new to them. Before i was using a PictureBox on the form and the code was working, but the only code i know for Data Reports so far is DataReport.Show , and Orientation for printing. anybody help me with this please.


Code:
sqlReport = "SELECT * FROM ClientsYearQuery WHERE (((ClientsYearQuery.DateRecorded) BETWEEN #" _
                                                        & txtDate1.Text & "# AND #" & txtDate2.Text & "#))"