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.

I have a record that is getting data from a qry ? do you mean form?

You can use the DCount() as the controlsource of a control on a form.

=DCount( ,"YourQueryName")