Microsoft Access query syntaxes for a report

[Manuel Baptista]

I am working on a database with a report with several indicators which have a few complex formulas.
However I cannot grasp how to write the formulas that will give me the results of 2 useful indicators.
To make it more simple, I am going to illustrate it with a simple hypothetical example: let's say the data base is about shirts. Please tell me what are the Dcount syntaxes that will give the following results:

1 - Number of items that in a given field do not match 3 possible answers.
I want to count the shirts whose colour (data base field) is not blue, red or green - i.e, they can be of any other colour.

2 - Number of items that in a given field do not match 1 possible answer.
I want to count the shirts whose colour is not blue - i.e, they can be of any other colour except blue.

I have tried the find the correct formulas but I have not succeeded.

[James Bowyer]

Well, (and I am not an expert, therefore I am sure there is a better way of doing this but...)

Why don't you dcount the total number of shirts, then dcount the number of shirts you don't want to include, and subtract the results?

[NeoPa]

Well Manuel, these answers may help, but bear in mind they are specifically for string field testing. Date or number testing would use different formats :

1. DCount("*", "[TableName]", "[Shirt] Not In('Red','Blue','Green')")

2. DCount("*", "[TableName]", "[Shirt]<>'Blue'")