Query all entries with only one column true

I have a database of characters for a drama. I want to query for all actors who show up in only one scene (each scene is a column). So basically I want to query for all rows that have one TRUE.

Have you reviewed the help or documentation? Base guide chapter 5.

I’m completely new to all this and have had no idea where to look. Thank you! I’ll see what I can do.

Ok, to be honest, I’m lost. Like a said this is my first attempt at this. I don’t know how to query a count of trues for a particular entry…

Hi, you might want to check out TheFrugalComputerGuys easy to follow video tutorials, just do a google.