[Hello i Hve the following code and i have run time errro that
there is a syntax error(missing operation) in query expression.
can you help me please?
Me.RecordSource = "SELECT * FROM qry_Logistikreview_Zeitfehlerein WHERE qry_Logistikreview_Zeitfehlerein.Zeit Fehler Ein BETWEEN #" & Replace(Format(Me.txt_StartDate.Value, "mm/dd/YYYY"), ".", "/") & "# " & _
"AND #" & Replace(Format(DateAdd("d", 1, Me.txt_EndDate.Value), "mm/dd/YYYY"), ".", "/") & "#"
DoCmd.Requery
there is a syntax error(missing operation) in query expression.
can you help me please?
Me.RecordSource = "SELECT * FROM qry_Logistikreview_Zeitfehlerein WHERE qry_Logistikreview_Zeitfehlerein.Zeit Fehler Ein BETWEEN #" & Replace(Format(Me.txt_StartDate.Value, "mm/dd/YYYY"), ".", "/") & "# " & _
"AND #" & Replace(Format(DateAdd("d", 1, Me.txt_EndDate.Value), "mm/dd/YYYY"), ".", "/") & "#"
DoCmd.Requery