count not changing

  • Thread starter Thread starter dave
  • Start date Start date
D

dave

Access97, i have report based on query. i added a count
field (=count)on the footer of the report to count the
number of records. Works only the first time, after i add
or delete records, this number does not change, i have
opened & closed access to refresh the data
thanks
 
Dave,
The count function must be written:
=Count(*)
Place it in the Report Footer, not the Page Footer.
 
Back
Top