SQL Where and Between

[CIIIHAN]

Hi there!

I'm trying to make an SQL statment which contain both the where and between

like this:

DoCmd.RunSQL "UPDATE MuhurDB SET location = " & Me.Location & " WHERE Grup =" & Chr(39) & grup & Chr(39) & " AND WHERE muhur BETWEEN " & fromTxt & " AND " & tillTxt

I get the error message about missing operators Error: 3075

What am I doing wrong?
Thanks in advanced!

 

[JANR]

Remove the second WHERE, marked in red.

DoCmd.RunSQL "UPDATE MuhurDB SET location = " & Me.Location & " WHERE Grup =" & Chr(39) & grup & Chr(39) & " AND WHERE muhur BETWEEN " & fromTxt & " AND " & tillTxt

JR

 

[smig]

Hi there!

I'm trying to make an SQL statment which contain both the where and between

like this:

DoCmd.RunSQL "UPDATE MuhurDB SET location = " & Me.Location & " WHERE Grup =" & Chr(39) & grup & Chr(39) & " AND [COLOR=red]WHERE[/COLOR] muhur BETWEEN " & fromTxt & " AND " & tillTxt

I get the error message about missing operators Error: 3075

What am I doing wrong?
Thanks in advanced!

you only need one WHERE clue

 

[CIIIHAN]

Thanks for the replies!
Deleting the second where did the trick!

 

[smig]

glad we could help