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.