Displaying number of records from another table

tmar89

Registered User.
Local time
Today, 18:41
Joined
Jun 16, 2003
Messages
30
I have a record that is getting data from a qry but I also want to display the total number of records from the table too. I tried this:

=Count([tblBnrStudent]![BnrID])

but it keeps asking me for the value of tblBnrStudent!BnrID.

I also tried using this:

=DCount([BnrID],"tblBnrStudent",???)

I wasn't sure what to put in the ??? if it wasn't null.
 

Users who are viewing this thread

Back
Top Bottom