If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Counting Blanks in Non Numeric Fields
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 |
#2
|
|||
|
|||
Counting Blanks in Non Numeric Fields
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. "caro" wrote in message news 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 |
Thread Tools | |
Display Modes | |
|
|