Hi Zed,
>
> The Table has one field named "Gender" and the gender is indicated by F,
> or M or M/F where a family is involved.
>
> What I was trying to achieve was a query which extracted the total
> numbers for each gender (e.g. 50, M25, M/F13) between a particular time
> period. In this case the period was BETWEEN 01/07/2020 AND 31/07/2020
>
> I have found several web pages which explain the syntax for SQL but, at
> my present level of knowledge, they are beyond my understanding :-)
You could show the code here.
Might be something like
SELECT "gender", COUNT("gender") AS "number" FROM "table" WHERE "date"
BETWEEN '2020-07-01' AND '2020-07-31' GROUP BY "gender"
Could also be you will show other content in the same query. Then you
have to create correlated subqueries.
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
