I have a table consisting of (unique) ITEMS and with a column LOCATION for the land of origin of the ITEMS. Some LOCATION fields are still empty.
A query counts the number entries in the LOCATION column for each country present. Essentially the GUI just shows the functions LOCATION 'group' and LOCATION 'count'. 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? Cheers Harvey -- 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