How get record count in DataSheet view

[Rick Charnes]

When I first open a table in Datasheet view, the status bar tells me
that I'm on record 1 but it doesn't tell me how many records there are.
At some point I see it eventually tells me "Record xxx...of xxxx" but I
never know how to force it to display that second number, total row
count. How/when does it eventually display the row count? Thanks.

 

[Kevin3NF]

I believe it shows that number after it has loaded all of the records into
memory. Ugh. Hopefully, this is not something you do very often.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/Newsgroups

 

[Rick Charnes]

Ugh is right. Then how I can I manually get this figure without loading
all records into memory?

 

[Kevin3NF]

Create a query:

Select Count(*) from MyTable;

I just ran this against one of my tables that has 122K records...came back
in half a second.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/Newsgroups