Count If (1 Viewer)

How do I count only filled out data in a query? I am using the count function and it counts blank and filled out records, I just want the filled out ones. Please be specific thanks

You must be using Count(*) use Count(fieldname)
I suggest you read help on Count

Brian

Count(*) counts ALL selected rows.
Count(fieldname) counts ALL non-null values of fieldname in selected rows.

Count(*) is faster on large recordsets since the database engine can frequently get a count by looking in its statistics. With Count(fieldname), the db engine will need to examine every row in the table so large tables might take some time.