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.
=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.