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

On 05/25/2013 08:37 AM, Dan Lewis wrote:
> On 05/25/2013 07:10 AM, Ian Whitfield wrote:
> > 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
>      If all you want is a count of the distinct countries in your 
> table, try this:
>
> SELECT COUNT( DISTINCT `Members`.`Country`) AS `Country`
> FROM `FedSaintsNew`.`Members` `Members`
>
> --Dan
     I forgot to mention one very important thing:
You must do this in SQL View. Then you must click the SQL icon. (This 
causes the SQL commands to be run directly. It will also prevent an 
error message because the Query Design dialog will not run this SQL 
otherwise.) After doing these things, run the query. You should get the 
number of distinct countries you have in your table.

--Dan

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