View Single Post
  #1  
Old May 3rd, 2010, 12:53 PM posted to microsoft.public.access.reports
Rob[_35_]
external usenet poster
 
Posts: 3
Default display a total value

Hello

I hope someone can shed some light on a slight problem. I am setting up a
database to hold personal information about pupils at our school. I have
set up a a Query by Form system linked to a report.

I've displayed the total number of records found at the bottom of the report
(Which I've done using a =count(Name) within a text box. What I'd like to
do is display the total number of records in the original (unsearched)
record set.

The bottom of the report would then read:

14 records found out of 30

using 2 text boxes and a label in the middle :

=count(name) found out of XXXXXX ----some kind of expression
which I can't figure out.

I've tried using =count(original_table_name!name) but this for some reason
still only displays the number of selected records and not the number from
the original set.

Any help much appreciated!

Rob