Count of records in table via query 1

[TeresePamela]

How can I get an SQL query to produce a count of the total number of records in a table? I am using Access/97.

Thanks for the help,
Pam

 

[dodge20]

Post this in the sql view of the query. Just replace table for whatever table you want.

select count(*) from table

Dodge20

 

[TeresePamela]

As you can probably tell, I'm new to Forum's and not sure if this is appropriate - but thanks a lot Dodge20 - this will be a great help,

Pam

 

[lespaul]

To show that an answer was helpful, click the link on the bottom of the post 'Mark this post as a helpful/expert post!' and you will give Dodge a star!

And it's very appropriate to express your thanks! We all appreciate it!

Have a nice day (glad you got your problem solved!)

leslie