Thanks Noel !!!
On 25/05/13 11:58, Marion & Noel Lodge wrote:
Assuming your field is 'Country', try this -
SELECT Country, Count(Country) AS 'Count'
FROM <your Table name>
GROUP BY Country
ORDER BY Country
I had a problem, at first - as I always seem to do - with 'Syntax
Error'!! So I created it with the Wizard and edited it in SQL view.
This resulted in ...
SELECT `Members`.`Country` AS `Country`
FROM `FedSaintsNew`.`Members` `Members`
GROUP BY `Members`.`Country`
ORDER BY `Members`.`Country`
This worked 100%!! So thanks very much. It does bring up two 'Blank'
results, (which I guess must have a space in them or something). I don't
know how to track these down but it's not too important.
Appreciate the help.
IanW
Pretoria RSA
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
