Hi zed,
>
> Thank you for your very prompt reply. I followed your instructions and
> it returned the sum of entries on the date entered. I obviously didn't
> phrase my questions clearly enough, for what I wanted was the sum of all
> entries for the period 01/07/2020 to 31/07/2020. I cannot find how to
> achieve what I want. so your further assistance would be very much
> appreciated.
SELECT SUM("No") FROM "Tablename" WHERE "First" between '2020-07-01' AND
'2020-07-31'
Regards
Robert
--
Homepage: https://www.familiegrosskopf.de/robert
--
To unsubscribe e-mail to: [email protected]
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
