Access RecordCount into index page

[potinenip]

Hi <br>I have a problem. I want to access the number of houses in texas from my &quot;property&quot; table and display the recordcount besides Texas which is in the index page(main page).<br>example:<br>missouri(26)<br>Texas(15)<br><br>I want to display 15 beside texas.<br><br>can somebody help me with that. <br>Thanks<br>Praveen

 

[SnakeHollywood]

SELECT&nbsp;&nbsp;&nbsp;&nbsp;distinct city, (select count(*) as total from companies where city = c.city)<br>FROM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;companies AS c<br><br>If your not using Access then you may need to remove AS to assign the alias.<br><br><br><br><br> <p>Russ Michaels<br><a href=mailto:russ@satachi.com>russ@satachi.com</a><br><a href=

http://www.satachi.com>Satachi

Internet Development</a><br>For my personal book recommendations visit

http://www.satachi.com/books.html<br>

<br>