Dcount with multiple excludes

[tagteam]

I am trying to use a dcount where the customerid is not 3 or 8 or 9



I have tried
=DCount("RailcarID",[AllRailcarData],"CustomerID <> 3 or CustomerID <> 8 or CustomerID <>9")


=DCount("RailcarID",[AllRailcarData],"CustomerID <> 3 or 8 or 9")

but neither work

The customer id filed is a number field

[Bulzie]

use "and" not "or"

[orange]

You can use the Not In() construct as well (a sample from my data)

Dcount("aname","animal","animalId not IN (1,3,4)")

[tagteam]

Thanks guys, I like the not in () way. Also for those who keep making bonehead mistakes like me, you have to have the table name in "" and not in brackets like i do above.