Query using 2 'nots'

[lawdy]

I can't get the following query to work anyway I try it.

What am I doing wrong?

[Minty]

What query?
Nothing attached?

[lawdy]

I pasted an example that did no show up. the code is:
SELECT tblItemCostRate.fDblItemOrder, tblItemCostRate.fTxtItemMaterial
FROM tblItemCostRate
WHERE ((Not (tblItemCostRate.fTxtItemMaterial)="firelane ATredPaint")) OR ((Not (tblItemCostRate.fTxtItemMaterial)="firelane ATgraPaint"));

Maybe this will do it.

[Minty]

It is a logic issue.

Your Query will always give you all the data from the table, as fTxtItemMaterial will always be either NOT firelane ATredPaint OR NOT firelane ATgraPain

I think you need an AND

NOT firelane ATredPaint AND NOT firelane ATgraPain

[CJ_London]

You also don’t need the ‘not’, just change the = to <>