I want to get only records between 2 dates in the data report in visual basic

Acqua

Do A search on the BETWEEN keyword and see if your provider accepts the keyword, if not try this: (the '#' are used for data values)

strSQL="SELECT * FROM Table WHERE Date1>=#" & strDate1 & "# AND Date1<=#" & strDate1 & "#"

Also try this control which has made my life easier:

http://www.geocities.com/scirocco_ha/DataControl.htm

dear friend
b4 applying this query i m failed to run the report
by using connecting string.
that is without data environment .
i applied 2 or 3 methods but the error i got is wrong arguments....
i m using ODBC access database.
i simply try to run the report with out criteria but failed.
in debug mode i passed the connection string, then
then i open record set query then
datareport.datasource= rs but when i asked to show the report
i got the message.
help me plz
acqua
---------------------------------------------------