G
Guest
I have a select query. However, I can't figure out a way of determining the
number of records returned by that query. I want to display that number in a
form or possibly subform. From what I've read, I need to use Dcount, but I
can't seem to get it to work properly within the query. I see what Dcount
can be used with tables, but I haven't seen where it can be used with
queries. I've also seen where one can use RecordSet.RecordCount, but I don't
know where to put that in my query. Any (hopefully, simple) solutions would
be greatly appreciated.
Thanks in advance.
number of records returned by that query. I want to display that number in a
form or possibly subform. From what I've read, I need to use Dcount, but I
can't seem to get it to work properly within the query. I see what Dcount
can be used with tables, but I haven't seen where it can be used with
queries. I've also seen where one can use RecordSet.RecordCount, but I don't
know where to put that in my query. Any (hopefully, simple) solutions would
be greatly appreciated.
Thanks in advance.