Count rows in a db.

[Tom123456]

I think this is an easy question for all experts her on the Access forum. Can I count the number of rows in a db?


- Tom

 

[TSSTechie]

Hi

If you look at the bottom of the table it should say record 'x' of 'y' where 'x' is the record that you currenty have selected and 'y' is the total number of records.

Hope this helps

May The Force Be With You

 

[Tom123456]

Hello TSSTechie, Yes but can i in code say for example:

if(NumberOfRows>5) Then
MsgBox "Message"
End if



- Tom