Count(Field) - (Group function)

Select first the required field, then use that command to apply a count on that field. That command will give the number of records where the concerned fields have a not null value, depending on all the other selected fields not affected by a Group function. It will generate automatically a GROUP BY statement in the SQL editor.

The selected field will change to Count(FieldName)

A command such as SELECT COUNT(TOTAL) FROM LIBRARY/TABLE will give the number of records from that table where the field TOTAL is not null (not empty).

A command such as SELECT SALESMAN, COUNT(TOTAL) FROM LIBRARY/TABLE GROUP BY SALESMAN will give the number of records for each different SALESMAN from that table, where the TOTAL field is not null or empty. If the TOTAL field is null for a SALESMAN, the COUNT(TOTAL) will retrieve the value zero.