Displaying record count in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there I have a query that I am using to count the total number of rows.It
is as follows
Select Count(*) from Job
All I want to do is display the results from this query in an unbound text
box on a report.I don't know how it is done.Could someone please help me out.
 
To show the number of records in table Job, set the Control Source of your
text box to:
=DCount("*", "Job")
 
MichaelAngelo said:
Hi there I have a query that I am using to count the total number of rows.It
is as follows
Select Count(*) from Job
All I want to do is display the results from this query in an unbound text
box on a report.I don't know how it is done.Could someone please help me out.
Click to expand...


If all you want is to display the number of detail records
in the report, then use a text box in the report
header/footer section. Set the text box expression to:

=Count(*)
 
Back
Top