How many records in access db

How can I write a query so that it will tell me the number of records in a database...

thanks

if you mean the number of records in a table:
select count(table.field) as RecNumber from table