Date: prev next · Thread: first prev next last
2021 Archives by date, by thread · List index


I have a database Reactors_Videos and three of the fields are:

No  (Field Type = Number (Numeric)
First (Field Type = Date (DATE)
Last  (Field Type = Date (DATE)

I successfully created a Query to display the total number of Reactions.

This Query takes the form

SELECT SUM( "No" ) FROM "Reactor_Videos Table 1"

I am now trying to create a Query which will display the number of reactions between any two dates but failing miserably

Most of them return the error : SQL Status: HY000 Error code: 1000 Syntax error in SQL statement" and an internet search reveals that this error is returned for any number of reasons, none of which are helpful to me (perhaps because of my lack of knowledge)

My latest attempt was

SELECT SUM( "No" ) FROM "Reactor_Videos Table 1" HAVING ( ( COUNT( "First" ) = 1 / 12 / 20 AND COUNT( "Last" ) = 31 / 12 / 20 ) )

This saved without any error messages but running the query results in no output

As will be apparent, my knowledge of the SQL language is minimal at best and any help members are able to offer will be very welcome.

Zed

--
To unsubscribe e-mail to: users+unsubscribe@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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.