|
 |
asp_databases thread: Count how many properties are in each town
Message #1 by "Oliver Dempsey" <odempsey@b...> on Sat, 9 Dec 2000 17:07:09 -0000
|
|
Whats the best way create a recordset to display the number of
properties in
each town?
Some towns may have no property, others have 1 or more<br>
e.g.
Town1 (2)
Town2 (0)
Town3 (4)
Town4 (3)
See database tables here
http://www.barrowvale.com/properties.asp
Regards
Oliver Dempsey
Message #2 by "Scott Munro" <samunro@y...> on Sun, 10 Dec 2000 01:34:24 +0800
|
|
If you create a query in Access that groups on NearestTownID and counts
PropertyID you should get the result you are after.
Create a query on the property table and click on the Totals button
(summation symbol) this will add another row to the bottom half of the
window labelled Total. Change the Group By entry for the PropertyID field to
Count. Reference this query when you create your recordset.
Cheers,
Scott.
-----Original Message-----
From: Oliver Dempsey [mailto:odempsey@b...]
Sent: Sunday, 10 December 2000 1:07 AM
To: ASP Databases
Subject: [asp_databases] Count how many properties are in each town
Whats the best way create a recordset to display the number of
properties in
each town?
Some towns may have no property, others have 1 or more<br>
e.g.
Town1 (2)
Town2 (0)
Town3 (4)
Town4 (3)
See database tables here
http://www.barrowvale.com/properties.asp
Regards
Oliver Dempsey
Message #3 by "Oliver Dempsey" <odempsey@b...> on Sat, 9 Dec 2000 19:59:30 -0000
|
|
Scott,
A thousand thanks,
you just saved me a whole lot of trouble!
Best Regards
Oliver
----- Original Message -----
From: Scott Munro <samunro@y...>
To: ASP Databases <asp_databases@p...>
Sent: Saturday, December 09, 2000 5:34 PM
Subject: [asp_databases] RE: Count how many properties are in each town
> If you create a query in Access that groups on NearestTownID and counts
> PropertyID you should get the result you are after.
>
> Create a query on the property table and click on the Totals button
> (summation symbol) this will add another row to the bottom half of the
> window labelled Total. Change the Group By entry for the PropertyID field
to
> Count. Reference this query when you create your recordset.
>
> Cheers,
>
> Scott.
>
> -----Original Message-----
> From: Oliver Dempsey [mailto:odempsey@b...]
> Sent: Sunday, 10 December 2000 1:07 AM
> To: ASP Databases
> Subject: [asp_databases] Count how many properties are in each town
>
> Whats the best way create a recordset to display the number of
> properties in
> each town?
> Some towns may have no property, others have 1 or more<br>
> e.g.
> Town1 (2)
> Town2 (0)
> Town3 (4)
> Town4 (3)
>
> See database tables here
> http://www.barrowvale.com/properties.asp
>
>
> Regards
> Oliver Dempsey
>
>
>
|
|
|
View Cart
