=Count

  • Thread starter Thread starter Es
  • Start date Start date
E

Es

I want to count the number of records that are displayed
in a report. I put a textbox in the footer with
=Count("*"), but I keep getting an error. What am I
doing wrong? All I want is a total number of records on
the report.

Thanks for your help
 
Hi.
Did you put the textbox in the page footer or the report
footer? It should work in the report footer.
If you want a running sum in the page footer you have to
take an other approach.
Hope this helps
Fons
 
Hi,

My name is Amy Vargo. Thank you for using the Microsoft Access Newsgroups.

You can apply the Count() function to a particular field. For example, say
you have a field named Field1 in the Detail section. You can use the
following expression to Count each record in the Control Source of a
textbox in the report footer section:

=Count([Field1])

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Amy Vargo
Microsoft Access Engineer


This posting is provided 'AS IS' with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.
 
Back
Top