Count non blank records in a column using calculated field

[astroboy]

I'm trying to create a syntax that will count the number of records that are not blank in one particular field. Is there anyway to do this using calculated fields?

[princezuko]

'Count Non Blank' is an aggregate function which means that this would work better if used in aggregation. However, I have here a different syntax that is similar to count non blank that you might want to try:

SELECT COUNT ([@field name]) FROM Table name WHERE [@field name] != ' '

Just make sure  to change the field name and table name according to your table name and design.