hello...

i am doing a report using data report..
the user can search the criteria that he/she wants..
what am i doing, there are 3 options, 1 checkbox..

the options, that is only one can selected...they are MiliNo, Name, and Door...

and the check box is date..

so that user can have one or two options (with date)...

how can i select two columns in the table?
why these codings doesnt work?
it only select the date only..not the door..
If CheckDate.Value = vbChecked And cboDoor <> "" Then
    Unload dedb
    Load dedb
    dedb.Commands(1).CommandText = "SELECT * FROM DailyAccess " & _
                                    "WHERE Date_In = cvdate ('" & DTPicker1 & "') AND Door = '" & cboDoor & "'"
                                    
    DataReport1.Orientation = rptOrientLandscape
    DataReport1.Refresh
    DataReport1.Show
    End If

iam using VB6 with database from ms access..

and one more thing, can i empty the DTPicker?
thanks..