[libreoffice-users] LibreOffice Base previously copying data from Calc to Base)...

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: 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