Counting records with duplicates

#11

I have printed this out and will give it a try.

Thanks a lot.

"FP" <a (AT) pottnerconsulting (DOT) ca> wrote

Quote:

There is another way to get a count or list of unique names.
Create a value list of the name field.
Set a global text field via script to:

ValueListItems ( Get ( FileName ) ; "VLNAMEHERE" )

This will put the contents of the value list into the global text
field. To get a count of the names, count the carrage returns + 1
because the last name doesn't have a carrage return. This also allows
you to get the names out by themselves if you need to work with them.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Counting records with duplicates

comp.databases.filemaker comp.databases.filemaker

Re: Counting records with duplicates - 08-27-2005 , 05:15 AM