Query all entries with only one column true

robertiii · September 3, 2020, 5:25pm

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.

mariosv · September 3, 2020, 5:33pm

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

robertiii · September 3, 2020, 5:45pm

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

robertiii · September 3, 2020, 5:56pm

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…

gkick · September 4, 2020, 5:41pm

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