Re: [libreoffice-users] LO Base - Question about Query [SOLVED]

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: users+unsubscribe@global.libreoffice.org
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