Hello
What I'm really trying to do is as follows:
1. Create a form for data entry in access (see attached).
2. Create a report that calculates "Yes", "No", "NA" and the "Percentage" for each category for each entry per location (see attached).
3. Create an aggregate report for all entries for all locations.
I'll be willing to pay you for your assistance with this project because I've spent all weekend trying to get it done and I'm back to square one i.e. creating the form with lookup tables as you have suggested. Please advise accordingly. Thanks!
Signed
Desperate in Delaware