Private Sub cmdGenRep_Click()
On Error GoTo errhandler
fdt = dtpFdate.Value
tdt = dtpTdate.Value
If cmboCountry(1).Text <> "-- Select Country --" Then
country = cmboCountry(0).Text
ElseIf cmboCountry(1).Text = "-- Select Country --" Then
MsgBox "Please Select Country", vbInformation, "Message"
cmboCountry(1).SetFocus
Exit Sub
End If
Call openStudent_Master
Set rsRep = New ADODB.Recordset
MsgBox dtpFdate.Value
MsgBox dtpTdate.Value
' str = "select stu_id,fname,lname,Con_Resi_stdcode,Con_Resi_no,Co n_Mo,course_preferred,comments from Student_Master where reminder BETWEEN " + dtpFdate.Value + " and " + dtpTdate.Value
str = "select stu_id,fname,lname,Con_Resi_stdcode,Con_Resi_no,Co n_Mo,course_preferred,comments from Student_Master where reminder > '" & dtpFdate.Value & "' and reminder < '" & dtpTdate.Value & "'"
MsgBox str
rsRep.Open str, cn, adOpenStatic, adLockReadOnly
Set drVA.DataSource = rsRep
errhandler:
MsgBox Err.Description
MsgBox Err.Number
End Sub

Actually I want to generate date wise report. My back end tool is MS Access.
I have a field named reminder which stores reminder date and whose data type is date/time.But while retrieving form database I am getting run time error 13 data type mis match . .

Please try

Str = "select stu_id,fname,lname,Con_Resi_stdcode,Con_Resi_no,Co n_Mo,course_preferred,comments from Student_Master where reminder > " & CDate(dtpFdate.Value) & " and reminder < " & CDate(dtpTdate.Value) & ""

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips &amp; Tricks (http://www.vbadud.blogspot.com)

The Query you gave is not working for me . .
Plz help me out through this. .I would be grateful . .

Harsh

Can youy please tell me if Is it throwing the error or is it not giving any result?

Can you try one part / other and try if it is leading you anywhere

Str = "select stu_id,fname,lname,Con_Resi_stdcode,Con_Resi_no,Co n_Mo,course_preferred,comments from Student_Master where reminder > " & CDate(dtpFdate.Value)

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips &amp; Tricks (http://www.vbadud.blogspot.com)

I used # around date values

Harsh
Thanks for all your reply