Hey guys, so I have I have form that tracks credit approvals with 3 credit providers. Very simple form "Did the customer apply for [credit provider]?" If the answer is yes, another option group appears to say "Were they approved?"
A 1 is a yes, a 2 is a no, in the table. My table looks like this:
I am trying to make a report that gives me approval percentages for all providers for a date range specified on the main form.
I can't figure out how to use the Totals to sum these correctly. I pretty much need a count of each column where that column equals 1. I tried:
But that only works when I do 1 category at a time. Without making a bunch of append queries to a table and doing them all separate, how can I do this simply?
Thanks!