Hi all , hope all is good. Could someone explain please where im going wrong with this where clause, initially it was ok as the criteria only had one argument, now that I am trying to use two criteria in the query I'm getting RTE 3464 datatype mismatch in criteria. The initial query I had that worked was this
Then i tried to change it to
and this is where i get the error I'm assuming its a formatting problem?? I've tried just using single single quotes around the 2nd where criteria but no joy. Bit confused as to why its a data mismatch by the 2nd query.
The idea being that it should be like this:
to use text4 AND Line fields to obtain the correct field.
Any help is appreciated
Code:
strSQL = "Update tblRma set removed = true, dateremoved = date() where text4 = " & Me!text4
Then i tried to change it to
Code:
strSQL = "Update tblRma set removed = true, dateremoved = date() where text4 = '" & Me!text4 & "' "
and this is where i get the error I'm assuming its a formatting problem?? I've tried just using single single quotes around the 2nd where criteria but no joy. Bit confused as to why its a data mismatch by the 2nd query.
The idea being that it should be like this:
Code:
strSQL = "Update tblRma set removed = true, dateremoved = date() where text4 = '" & Me!text4 & "' AND Line = '" & Me!Line & "'"
Any help is appreciated