hello .Can anybody help me with the sql syntax of searching
hello .Can anybody help me with the sql syntax of searching
(OP)
Ihave following problem.
in cells i have values
critdate = Sheets("työ").Range("b1").Value
critkonesk = Sheets("työ").Range("B2").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 #' ) " _
& " ")
i am very greatfull for help
in cells i have values
critdate = Sheets("työ").Range("b1").Value
critkonesk = Sheets("työ").Range("B2").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 #' ) " _
& " ")
i am very greatfull for help




