hello .Can anybody help me with the sql syntax of searching

[marre]

Ihave following problem.
in cells i have values
critdate = Sheets("työ&quot.Range("b1&quot.Value
critkonesk = Sheets("työ&quot.Range("B2&quot.Value
I suppose to use "dao" and want to get information from access database
I know that access fields have many sorts of format (txt,date,counter ,memo ,,,)
i succed with text format "critkonesk"
but the problem is "critdate"
tell me the syntax for such a matter

Set rs = db.OpenRecordset _
(" SELECT [KONE-pKORTTI].* " _
& "FROM [KONE-pKORTTI]" _
& "WHERE ([KONE-PKORTTI].konesk LIKE '" & critkonesk & "') " _
& "AND ([KONE-PKORTTI].PVM LIKE '# critdate #' ) " _
& " &quot

i am very greatfull for help