Count

[Pauldohert]

I am gradually moving all my queries - to views, sp on SQL with the idea that eventually I will move the front end from access completely.


However - I have a form - whic basically displays a Dcount (with access) of a query. Now I have moved the query to a view (its not directly linked to may access from end - it is got at using pass thru queries) , what would be the best way to get the count of the records. (I have the syntax for the SQL)

Baically I need a count of records in a sql view, with acces doing as little as possible , just showing the result?

Hope that makes sense.Thanks

 

[Dennisk]

SELECT COUNT(*) FROM myTable will give the number of rows in myTable

 

[cchaalan]

Counting records in multiple table in one query

Hi,
I used the info in the previous record to count the # OF RECORDS in one table in my query. Is there anyway, to count other table records in the same SQL Query?
This counts the total records for table 1:
SELECT Count(*) AS TNAME1 FROM T_name1;
Please help & Thank you in advance.
cchaalan