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)