Apache OpenOffice Community Forum

Posted: **Mon Nov 02, 2026 3:14 pm**

I have a query to check how many items are in each location, but how do I tell it I only want it to count those marked unchecked?
Current: SELECT "Location", COUNT( * ) AS "count" FROM "Master List" GROUP BY "Location"
There's 86 items listed as being on Shelf 4, but I want to know how many of them are checked or not.
Thank you.

Posted: **Mon Nov 02, 2026 5:08 pm**

If the column that marks the checked status is called Status, the query would look something like

Code: Select all

 SELECT "Location", COUNT( * ) AS "count" FROM "Master List" WHERE "Status" = 'checked' GROUP BY "Location"

Posted: **Tue Nov 03, 2026 12:07 pm**

Yep, does exactly what I want. Thank you.

Apache OpenOffice Community Forum

[Solved] List of locations with number of unchecked items

[Solved] List of locations with number of unchecked items

Re: List of locations with number of unchecked items

Re: List of locations with number of unchecked items