Counting text values in Access 2003 Report

[Jideogu]

I have a database with about 30 fields. Each field contains five possible choices such as:
Correct
Policy Incorrect
Information Disregarded
No Verification
Verification Not Required
745 Potential

If I reviewed 15 cases from one Case Manager, I want a report that will tell me for EACH FIELD, how many is “Correct”, “Policy Incorrect”, “Information Disregarded”, etc.

Your help is greatly appreciated. My knowledge in Access is limited. Showing me how to do this will be very helpful.

Thanks.

 

[vbaInet]

Are these list of choices in a separate table?

 

[Jideogu]

No. They are typed in.

Thanks.

 

[vbaInet]

In that case that table isn't fully normalized.

1. Create a table for those records and have an AutoNumber field to uniquely identify each record
2. Perform an update on your original table to replace the values with its respective IDs
3. Open the original table in design view and change that field's datatype from Text to Number
4. Go into your Relationships and link the ID field from the new table to the Number field in your original table

If you want to use that field in the original table in your form then you can use a combo box control to return the text of that number.

Once you've got this setup we can sort out the count.