Hi Ian, Glad you got it working - there are often subtle differences between different flavours of SQL.
If you would like to track down the two blank records, you could try - SELECT * FROM `FedSaintsNew`.`Members` `Members` WHERE `Members`.`Country` = ' ' Not sure what your syntax might be in the last line - if it doesn't work try - WHERE `Members`.`Country` = " " If ever you wanted to know how many people you have from each country, you could experiment with adding - , Count(`Members`.`Country`) AS 'Count' or perhaps - , Count(`Members`.`Country`) AS "Count" to the end of your SELECT line. Noel -- Noel Lodge lodg...@gmail.com On 25 May 2013 21:10, Ian Whitfield <whitfi...@telkomsa.net> 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 > > -- > To unsubscribe e-mail to: > users+unsubscribe@global.**libreoffice.org<users%2bunsubscr...@global.libreoffice.org> > Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** > unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/> > Posting guidelines + more: http://wiki.**documentfoundation.org/** > Netiquette <http://wiki.documentfoundation.org/Netiquette> > List archive: > http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/> > All messages sent to this list will be publicly archived and cannot be > deleted > > -- To unsubscribe e-mail to: users+unsubscr...@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
