Thanks for reply. Unfortunately I'm a newbie with Access SQL and coding so appreciate your patience.
Can you please explain in more detail (maybe code example?) how this would work.
The problem I am having is doing and displaying this across multiple columns. I.e. I want to see the count of all the fails for ONLY the CO_mtm column, all the fails for ONLY the CO_log column, etc. etc.

So my end result would be something...

I am trying to count the number of Pass and Fails across several different columns.
For example, I have 10 columns that each result in a value Pass or Fail. I want a query that gives the count of all of each of those columns broken down by # of Pass and # of Fails.

I used this code to count all of the Fails on 1 column:
SELECT COUNT(CO_mtm) AS CO_mtm_FAIL FROM FXCompare
WHERE CO_mtm='FAIL'

This...