Counting of Filtered Records

[Guest]

I would like to count the number of record in my query...

Is it possible to display counting like - "# out of ## Projects"

I mean, if i am going to filter my record based on the Project Location, let
say, I have 500 Projects for USA, and then 10 out of that number are Projects
in MIAMI..

I would like to display a "10 out of 500 USA Projects" caption in my
report...

how will i do that..

Thank you...

amsuria

 

[Marshall Barton]

I would like to count the number of record in my query...

Is it possible to display counting like - "# out of ## Projects"

I mean, if i am going to filter my record based on the Project Location, let
say, I have 500 Projects for USA, and then 10 out of that number are Projects
in MIAMI..

I would like to display a "10 out of 500 USA Projects" caption in my
report...

You can use the aggregate functions in form/report
header/footer section text boxes to calculate totals of the
records in the form/report's record source table/query.
E.g. a text box named txtTotal in a report's header section
can use the expression =Count(*) to display the number of
records in the report.

You can do the same in a report's group header/footer
sections to calculate totals of the records in the group.
E.g. if your report is grouped on the country field, a
country group header/footer text box can display what you
want by using the expression:
=Count(*) & " out of " & txtTotal & " projects"