Stumped on creating an approval percentage

[snipe]

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!

[orange]

snipe,
Can you pass the data in that table to us as a csv?
And you haven't shown us where category fits??

Don't know that I can help, but having the data and "the issue" will give it a try.

[snipe]

T_Finance_csv.csv.zip

The table isn't populated yet. The snippet above is just some generic test data. But I'll attach it so you can play around.

The columns (sorry, I called them categories earlier) show if a customer applied for a provider, and then if they were approved. [Sync] = 1 means a customer applied for "Synchrony", a 2 means they declined to apply. [SyncAppr] =1 means they were approved for Synchrony. [SyncAppr] can be null if the customer declined to apply. The three companies are "Synchrony" (primary financing, interest free), "RMC" (secondary, financing with interest), and "Acceptance Now [ANOW]" (tertiary, rent-to-own financing). If a customer is approved for Sync, they very rarely will apply for RMC or ANOW, so there will be nulls for those most of the time. A null value does not equal a 2.

I just need a sum of the total applications, and the total approvals for each provider. I know I can do this just buy making 6 append queries; any time the report button is pressed, the table would be cleared and repopulated by the append queries. For my own gain in knowledge, I wanted to see if this could be done purely with a a couple queries.

Did that answer your questions?

[orange]

OK for now, and not promising anything. I like your "play around" term --- that's about it.