Displaying the total count of a single field query

[kaluapig]

Hello,

Could anybody help me understand why I can use a single field in a query, put a count (from the Totals view) on this field and display the total occurances for this field, but I cannot get any count to display as soon as I enter a criteria to filter out this field to obtain the filtered count?

Thanks

 

[azzie_B]

I have had the exact same problem and It is very frustrating. I hope someone can help us both.

 

[kaluapig]

Azzie,

I'm glad I'm not the only one. Those with more experience probably know the answer by heart, but for us newbies, it is very frustrating when something so simple just does not work.

ANY PROs OUT THERE .... HELP!

Thanks,

Nick

 

[meboz]

Are you attempting to place the filter criteria in the same column as the Count field? That could be causing you troubles.

Otherwise it should be as simple as...

SELECT Count(table.field) FROM table WHERE table.field = filtervalue;