AND in Where Condition

[Adam McReynolds]

I got this code to run correctly, which pulls records where they are not junk(can be seen at end of where condition), the only issue is that the "AND" does not turn blue. Is this a problem?

If Not IsNull(Me.txt_last_rec_id) Then
'DoCmd.SetWarnings = False
SQLText = "INSERT INTO tbl_batt_id " & _
"(record_num, bat_id, manufacture, date_code, barcode, status) " & _
"SELECT " & Me.record_num & ", bat_id , manufacture, Date_Code, barcode, Status " & _
"FROM  tbl_batt_id  " & _
"WHERE record_num = " & Me.txt_last_rec_id & " And [Status] <> 'Junk'"


Debug.Print SQLText
DoCmd.RunSQL SQLText
'DoCmd.SetWarnings = True
End If

 

[Galaxiom]

The And is inside a string. As such it is a different kind of And from those that the editor formats.

 

[CJ_London]

no - because it is text

 

[Adam McReynolds]

Thanks Galaxiom and CJ_London! I can sleep soundly tonight. Cheers!!!