Attention: Robert Grosskopf
My apologies for not following convention and replying in the normal
manner but I rather foolishly deleted your advice by mistake,
The information you gave me regarding my request for help on how to
construct a query was just the guide I required to solve my problem. I
was also able to construct two other queries. In one I was successful
in extracting the information I required but not so successful in the
second.
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 :-)
Zed
--
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