So you want to show the percentage of records that have some value (any
value) in a particular field?
1. Create a query.
2. Depress the Total button on the toolbar.
Access adds a Total row to the design grid.
3. Drag the primary key field into the grid.
In the Total row under this field, choose Count
4. Drag your other field(s) into the grid, choosing Count again.
This gives you the count of all records (since the primary key is there in
each record), and the count of records that have something in each other
field.
You can now add other fields to give you the percentages. For example, if
your primary key is named ID, and you want to count the number of records
that have something in the field named City, enter this into a fresh column
in the Field row:
[CountOfCity] / [CountOfID]
and choose Expression in the Total row.
To display that result as a percent, right-click the field, and choose
Properties. Set the Format property to Percent.
