Access function to count records

[mbaptista1970]

Hello,

I am attempting to count records within a data base that do not match one possibel 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, Portugal. What is the Access function formula that will deliver that answer?
Data base: Member Companies
Table: Companies data
Field: Headquarter
Best regards,

Manuel Baptista

[pbaldy]

Depending on how/where you want the answer, you can use SQL or a DCount() function, with the appropriate criteria (Headquarter <> "Portugal").

[mbaptista1970]

Dear Mr. Paul Baldy,

Thank you so much for your answer. It solved me a problem that I have been trying to fix for several months!
There is just one more thing I would like to ask you: to count records that do not match more than 1 possible answer in a given field - using my former example, let's say I want to exclude 2 countries, Portugal and Spain - how can I use the function Dcount the way you told me and separate these two answers? I have tried using a comma (Headquarter <> "Portugal", repeating the symbols <>, leaving blank spaces but none worked out.
Regards,

Manuel
Lisbon, Portugal

Depending on how/where you want the answer, you can use SQL or a DCount() function, with the appropriate criteria (Headquarter <> "Portugal").

[pbaldy]

You probably didn't repeat the field name. Try

Headquarter <> "Portugal" AND Headquarter <> "Spain"

In SQL you could also use

...WHERE Headquarter NOT IN("Portugal", "Spain")

Say hello to my friend Estuardo who also lives in Portugal.

[mbaptista1970]

Dear Mr. Paul Baldy,

Thank you so much for your 2 answers regarding the MS Access "DCount" function.
Both were totally useful and solved me 2 problems that I had been trying to fix for several months!
You really have an extensive knowledge of the programme.
Best wishes,

Manuel Baptista
Lisbon, Portugal
(mbaptista1970@gmail.com)

[mbaptista1970]

Dear Mr. Paul Baldy,

Thank you so much for your 2 answers regarding the MS Access "Dcount" function.
Both were totally useful and made me solve 2 problems I had been trying to fix for several months!
You really have an extensive knowledge of the programme.
Best wishes,

Manuel Baptista
Lisbon, Portugal
(mbaptista1970@gmail.com)

[pbaldy]

Happy to help Manuel; good luck with the project.