I have a file with two tables. One is Students (one record for each student
in the building) and the a Library Visits table. When the student comes to
the library, a new record is created in the Library Visits table by entering
the Student ID. Various information is tracked with the Library Visits
table. The librarian just informed me she needs a report to determine how
many students have come to the library at least one time this year. She
does NOT need to know how often they are coming, but just how many have
visited this year. I made a subsummary report and it is showing each
student once but when I try to do a record count (for number of students) I
am getting a count of the total number of visits. What do I need to enter
to get a count of the number of students who have made at least one visit?

Thanks

FMP11 on Win XP

"Stephen Larivee" <lariveesl (AT) yahoo (DOT) com> wrote

There's two possibilities ...

* If the report is only for a single year (not really a report at all)
i.e. 2009 507 visits
then since you don't need to know how often they are visiting, the best
option would be to produce the report using the Students Table. You can
first Find the records for the students who have visited this year,
e.g. Library Visits:ate 1/1/YYYY ... 30/12/XXXX
and then a Summary field can simply Count the number of records in the
same way that you had in the Library Visits table.

* If the report is for multiple years
i.e. 2009 507 visits
2008 525 visits
2007 492 visits
TOTAL 1524 visits
then things get a bit messy, so it's not really worth going into this if
you
don't need this type of historical report.

Helpfull Harry )