I can't get the following query to work anyway I try it.
What am I doing wrong?
I can't get the following query to work anyway I try it.
What am I doing wrong?
What query?
Nothing attached?
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
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.
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
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
You also don’t need the ‘not’, just change the = to <>