counting -.number of records.

  • Thread starter Thread starter Mickey
  • Start date Start date
M

Mickey

I'm trying to show the number of records in a query in a
report -Can anyone help me?
 
Add a text box to the report header or footer with a control source of
=Count(*)
 
Thank you! now, can I show that (the total # of records)
from several different queries in one report?
Thanks in advance
Mickey
 
A report can have only one recordsource/query. You can use subreport that
are bound to their own query. Another method is to use a text box bound to
the control source of:
=DCount("*","tblYourTable")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
How to i count a record with muptiple yes no fields 2
Access Counting records based on multiple age bracket and output to tabulated report 0
counting records 0
Count of Multiple queries 4
Query is showing invalid totals (due to multiple records) 0
Count Within a Range 2
Counting records and Where criteria 2

Back
Top