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
GROUP BY Country
ORDER BY Country
I
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
GROUP BY Country
ORDER BY Country
I had a problem, at first - as I always seem
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 t
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
GROUP BY Country
ORDER BY Country
I had a problem, at first - as I always seem to do - with 'Syntax
Error'!! So I created i
Hi Ian,
Assuming your field is 'Country', try this -
SELECT Country, Count(Country) AS 'Count'
FROM
GROUP BY Country
ORDER BY Country
Noel
--
Noel Lodge
lodg...@gmail.com
On 25 May 2013 19:09, Ian Whitfield wrote:
> Hi All
>
> I have a Database with about 3000 addresses in it an
Hi All
I have a Database with about 3000 addresses in it and need - from
time-to-time - to check how many different Countries are listed in it.
I have a Query that extracts this for me but naturally it pulls out
EVERY entry for EVERY Country.
Is there a way for a Query to do this BUT only l
