Dcount function criteria excluding one possible answer

[Manuel Baptista]

Good afternoon,

I am attempting to count those records within a data base that do not match one variable answer in a given field.
To put it more clearly, I want to count the companies in a database that are headquartered in several several countries except one, namely Portugal. What is the Dcount function formula that must be used?

Best reagards,

Manuel Baptista

[missinglinq]

Substituting your actual names:

DCount("*", "CompanyTable", "[CountryFieldName] <>'" & "Portugal" & "'")

Welcome to Bytes!

Linq ;0)>