DoCmd UPDATE , Problem with where criteria 1

[DemonHub]

I need help with this code

DoCmd.RunSQL "UPDATE CocheDivers SET Diver1 =" & div1 & ", Diver2=" & div2 & _
", Diver3=" & div3 & ", Diver4=" & div4 & _
" WHERE NumDossier=" & "'" & Me!NumDossier & "'" & _
" AND Critere=" & "'" & Me!Criteres1 & "'" & _
" AND DateRecu=" & Me!DateRecu


The criteria DateRecu is not working and I don't know how to fix the problem.
It's look like he can't compare the two dates.

 

[lupins46]

AND DateRecu=#" & Me!DateRecu & "#

 

[DemonHub]

Nop sorry that doesn't work

" AND DateRecu= date'" & Me!DateRecu & "'" <- Dont work
" AND DateRecu= date(" & Me!DateRecu & ")" <- Dont work

 

[lupins46]

If dateRecu is a datetime field you must have #..# around the value.
If you do not have US regional settings you need to reformat your date:
" AND DateRecu=#" & format(Me!DateRecu,"yyyy-mm-dd") & "#

 

[lespaul]

what's the extra "date" for? Where are the # signs?

" AND DateRecu= date'" & Me!DateRecu & "'"
" AND DateRecu= date(" & Me!DateRecu & ")"


Is NumDossier a Text field? There's ' marks so that would indicate text. What about Critere? is that text too?

I would also speculate that your table isn't normalized by the glaring indicators: Diver1, Diver2, Diver3, Diver4. Have you read The Fundamentals of Relational Database Design?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

 

[DemonHub]

Thx lupins46 , it's work great now