Hi zed, you have to set the filter in subquery. Could be this is what you want to get:
SELECT SUM( "No" ) FROM (SELECT * FROM "Reactor_Videos Table 1" WHERE "First" >= '2020-12-01' AND "Last" <= '2020-12-31' ) You have to set the dates SQL-like in format 'YYYY-MM-DD' 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