counting records

[Danny]

Hey,

I imported a table into my Access 97 db. I am not sure if
the whole thing got transferred and want to check how to
count the records in a table. I have almost 5 million
records so can't really scroll down and do it.

Thanks in advance.

Danny

 

[Lynn Trapp]

Create the following SQL query.

SELECT Count(*)
FROM YourTable;