You just need something to mark your courses as "complete", I would probably use a Yes/No checkbox in the table. Then you can do a DCOUNT DCount of the number of completes you have, compare that with a DCOUNT of the available courses.

Or if you want to use statuses instead of a checkbox, you could again use DCOUNT but do a count on the number of records where the status = complete or status = draft etc.

AGGREGATE?
Group by Status then calculate based on those.

What I am doing is ... I have a table of listed courses. I have 30 courses in various states of completion:
1. IN progress
2. Review
3. QA
4. Complete
I then did a count to get a number of how any were in each status I have 2 in complete status, 5 in in progress status, 10 in QA status
What I was hoping to do was to get a percentage count on that information. Based on the count what is the over percentage for each status.
So out of the 30 records with 2 being in Complete status what is that percentage, with 5 in in progress what is that percentage, with 10 in QA what is that percentage. I am new to access and am trying to learn, I have watched many of the courses but am finding it difficult to find a match for what I would like to do.

Teri, this can be tricky to do. The guys pointed you in the right direction. This is a little tricky to do, but would make for a good Fast Tip video for today... so watch both of those other videos and then hang in there... a new video to tie them together is coming.

How would you calculate the % on paper?

Here you go, Teri: Percent of Count

OMG, Richard Rost, That was brilliant! It was exactly what I needed for that issue. I cannot thank you enough!!! It works perfectly. My error was I was trying to get my results in the same Query, I needed that Second Query for the results. I am so Happy I am dancing on my desk!

You're very welcome. Platinum membership has its privileges. 😁