count not changing

[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

 

[Fredg]

Dave,
The count function must be written:
=Count(*)
Place it in the Report Footer, not the Page Footer.