Query Transferring Specific Postcodes And Shouldn't

[DMT Dave]

Hi Guy's, i have this simple query where i am trying to update tblRoutes From tblEdit within the shipment week

So i am trying exclude 14 postcodes (if any exist in the specific week) therefore using simple method of



In the criteria of Postcodes, i have got the following
<> "Postcode1" Or <> "Postcode2" etc up to Postcode14

When I run the code, if there are postcodes within that week that i am trying to exclude, they are pulling through and adding to tblRoutes

I would have thought using the criteria that I have, it shouldn't pull them through ?

strSQL = "INSERT INTO tblRoutes ( DelTo, Town, PostCode ) " _
        & "SELECT qryCheckAdded.DelTo, qryCheckAdded.Town, qryCheckAdded.PostCode " _
        & "FROM qryCheckAdded;"


Set rs = CurrentDb.OpenRecordset("Select * From tblRoutes WHERE Driver Is Null")
    
Do Until rs.EOF
    
    With rs
    .Edit
    !DelDate = Format(Now(), "dd/mm/yyyy")
    .Update
    .MoveNext
    
    End With
    
Loop


    DoCmd.SetWarnings False
        DoCmd.RunSQL strSQL
    DoCmd.SetWarnings True
        
    Forms!frmPlanning!frmPlanningDS.Requery

[June7]

<> with OR does not work how you expect. Try AND.

Or use NOT IN()

NOT IN("postcode1", "postcode2", ...)

[orange]

Google

De Morgan's Laws

for details.

[isladogs]

You shouldn't group by Postcode with criteria Is Null. Change that from Group By to Where.

Possibly one or both of the other field with filter criteria should also be Where

[DMT Dave]

Thank you guy's
Changed to June7 approach
NOT IN("postcode1", "postcode2", ...)
Changed to Colin's suggestion from Group By to Where in the NULL field

Works great
Thank you