Can someone pls help me on how I can query my database to count “yes/no” values and display them as a count?
Closing in on the finished product but now I am trying to display (aka do the math) the stats from the database.
My database has two players, and there is a yes/no column in the database titled Kyle won (yes/no) and Peter won (yes/no). To display how many times Kyle won I just need to ping the data and count only the YES values. I am no sure how to do this part, do I use a text box? How do I make this simple count function?
Hi there, @kyle4… you can use a text box to display that count, and getting the count is easy. In the text box, do a search in the appropriate data type, and add a constraint to the search where the Kyle won field is yes. Then, where you configured the search in the text box, click (More…) and select the :count option. At that point, your text box should display the number of times that Kyle has won. Make sense?
