counting unique names

[Corvida]

Hi!

I've created a database to keep track of student counseling appointments. I need to be able to count how many individual students came in for appointments. Right now I'm using a field (student name) that will create it's own value list so that the names are always spelled correctly (or at least one way so that duplicates can be found). If I use omit multiples, the names that are in the database more than once don't show up at all and they need to be counted (once) when I count the number of individual students seen.

Any ideas? Thanks VERY much!

Corvida

[mr_vodka]

If you are looking at a found set of your appointments for a certain date range, then all you have to do is a Go to Related Records ( match found set ) to the Students table to know which students were a part of those appointments.

If you are using FM7 though, I dont think that option was available until FM8. If not, then you will need to loop through those records and omit duplicates. Do an advanced search on these forums for +delete +duplicates or +omit +duplicates.