Simple Row Count Of Table

[ellisplace]

I have an Mp3 database which compiles a list of the ID3 tag data and
sorts it appropriately. I have created a form which searches within the
table for the keyword you put in. I want to put some text on this form
to say how many tracks there are currently in the database.

Nothing fancy just want it to read the number of rows within my table
and return that value onto the form itself as text.

I tried finding a solution myself but I am not skilled at all when it
comes to Access.

Any help will be greatly appreciated.

 

[Guest]

Create a totals query that gives you the number. In your form add an
unbound textbox. Enter the query as Control Source.

 

[Douglas J Steele]

Either that, or set the Control Source of the unbound textbox to
=DCount("*", "MyTable")

(Replace MyTable with the actual table name. Include the = sign)