Get ready for BLACK FRIDAY shopping starting in

Forums

This topic is locked

Counting rows in a table

Posted 19 Oct 2001 22:27:56
1
has voted
19 Oct 2001 22:27:56 Alex Xander posted:
Anyone know how can i count the rows on a table??
cause i need to get the total

Replies

Replied 19 Oct 2001 23:28:18
19 Oct 2001 23:28:18 Owen Eastwick replied:
If you look in the Data Bindings pallete, click the plus symbol next your recordset name you will find the recordset stats that you can drag on to the page as dynamic text.

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo
Replied 03 Apr 2002 18:49:08
03 Apr 2002 18:49:08 Kutt Niinepuu replied:
Ok, Owen, you seem to be a proficient SQL user. Try this <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

I have a table containg id, theme, name, comment, url, previewurl. (aÍt's a picture bank.) And I want to list the count of records under a certain theme, ie. theme=summer2001 -&gt; how many records are there with this theme.

Should I use subqueries or is it handled by Group By or sth else?

(You'll probably be laughing by now!)

Less is more1

Reply to this topic