Town (5) - how to pull this out of database/recordset?

[Nathon Jones]

Hi.

Access/VBScript/ASP

I have a table of records. Each record has a "town" field. Some of the
records are from the same town.

How do I:

1) Group the towns, in order to display a town list on the site:

Aberdeen
Edinburgh
Glasgow

2) Incorporate the "total number of matching records" into this list for
each town, like so:

Aberdeen (2)
Edinburgh (4)
Glasgow (3)

Hope someone can help. Thanks.

Nath.

[Singularity.co.uk]

Nathon

Try the following:

SELECT TblAddress.City, Count(TblAddress.City) AS CountOfCity
FROM TblAddress
GROUP BY TblAddress.City
ORDER BY TblAddress.City

Brendan

"Nathon Jones" <nathonjonesNOT@kirkmoor.com> wrote in message
news:d0sb6f$6sh$1@forums.macromedia.com...

> Hi.
>
> Access/VBScript/ASP
>
> I have a table of records. Each record has a "town" field. Some of the
> records are from the same town.
>
> How do I:
>
> 1) Group the towns, in order to display a town list on the site:
>
> Aberdeen
> Edinburgh
> Glasgow
>
> 2) Incorporate the "total number of matching records" into this list for
> each town, like so:
>
> Aberdeen (2)
> Edinburgh (4)
> Glasgow (3)
>
> Hope someone can help. Thanks.
>
> Nath.
>
>

[Julian Roberts]

You'd have

select town,count(town) as towncount from mytable group by town

For more on the basics of SQL see

[url]www.sqlcourse.com[/url]
[url]http://www.w3schools.com/sql/default.asp[/url]

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[Nathon Jones]

Supoib!

Nath. :))

"Singularity.co.uk" <Brendan.Collins@RemoveThisSingularity.co.uk> wrote in
message news:d0sbgv$7he$1@forums.macromedia.com...

> Nathon
>
> Try the following:
>
> SELECT TblAddress.City, Count(TblAddress.City) AS CountOfCity
> FROM TblAddress
> GROUP BY TblAddress.City
> ORDER BY TblAddress.City
>
> Brendan
>
> "Nathon Jones" <nathonjonesNOT@kirkmoor.com> wrote in message
> news:d0sb6f$6sh$1@forums.macromedia.com...

>> Hi.
>>
>> Access/VBScript/ASP
>>
>> I have a table of records. Each record has a "town" field. Some of the
>> records are from the same town.
>>
>> How do I:
>>
>> 1) Group the towns, in order to display a town list on the site:
>>
>> Aberdeen
>> Edinburgh
>> Glasgow
>>
>> 2) Incorporate the "total number of matching records" into this list for
>> each town, like so:
>>
>> Aberdeen (2)
>> Edinburgh (4)
>> Glasgow (3)
>>
>> Hope someone can help. Thanks.
>>
>> Nath.
>>
>>

>
>