Hi Harvey,
SELECT `Location`, COUNT( `Location` ) FROM `Item_Management`.`Items`
`Items` GROUP BY `Location`
The result is correct for all LOCATIONS that are not empty, but
surpisingly the blank field for the empty locations is accompanied by
the value 0. How can I get the right count for the empty fields as
well?
Try this:
SELECT COALESCE(`Location`,'Empty') AS `Loc`, COUNT( `ID` ) FROM
`Item_Management`.`Items` GROUP BY `Loc`
COUNT: Always use a field which should never be NULL (primary key for
example)
Set a vallue for a field, which is empta at this moment. If "Location"
contains characters it will work with 'Empty' as shown above.
Didn't test it!
Regards
Robert
--
Homepage: https://www.familiegrosskopf.de/robert
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy