Counting Blanks in Non Numeric Fields

  • Thread starter Thread starter caro
  • Start date Start date
C

caro

I am trying to see how many blank spaces employees leave when filling out a
particular form. These fields are generally non numeric, though there are a
few check boxes too. Is there an equation I can use in the report footer that
would add up the total number of blanks? The goal would be to use that
information and divide it by the total number of fields to produce a
percentage of complete forms.
Many thanks,
Caro
 
You'll need to decide what constitutes a "blank".

If someone enters something, then deletes it, is that a "blank"?

If someone skips past a field, is that a blank?

If someone tabs into a field and presses the spacebar, is that a blank
(looks like one to humans!)?

You could probably use code in a BeforeUpdate event for the form to check
for fields that had not been (?properly?) completed... but that's on a
one-by-one basis.

You could probably use a query against the table itself to count records
that had (your definition of) blanks in fields, any of the fields.

If you created another query that counted all records, you could calculate
total w/ any blanks divided by total.

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Back
Top