Very Computer

I have a database of bird observations.  In the "name" field are hundreds of
entries, with a given bird name appearing many times (for each time it was
observed).  I can look at a list of unique species using a sub-summary part
sorted by "name" (so that each species in the "name" field is listed only
once), but I haven't figured out how to get FM to count those unique values.
Everything I've tried gives me the total number of occurrences for all the
species listed, not the number of unique species. If you can help out,

Also:  is this any easier in FM4 or FM5? Thanks.  

I think i could use that file too ;p
Having probleme to ensure that a username is unique for a specific database.
I made a field that is auto entered and must be unique that is equal to the
database_name & " " & userName
But for some reason, the field is only updated when the databse is selected and not
the username.
I would also like to have a pointer on how to use the same passwordlist from the
web security database for different database..so that i only have to enter users
info once and not once for each database (if i had a new user in database one it is
automaticly added in 2 and 3).
Should i make a relation field  and then select the  add related field in the
security database? but then how can i put specific permissions?
Anyway, just having the info on how to count those unique values would be great. i
am using fm4.
Will probably migrate on fm 5 later.