Hello. I have created a DB to manage our projects (ATM installations). Once a week a summary report is provided to upper management giving them the status of each project. On this summary report they want to see a "percent complete". This percent is derived from the status fields (approvals, ordered, received, ready to ship, and completed). These fields are check boxes on the data entry form. Each of these should be equivalent to 20% so when all are checked the project is 100%. I am at a loss at how to create a query that will look at all 5 fields and return the appropriate completion percentage. Thanks in advance!