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
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 -> 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
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 -> 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