Count found records

[projay]

Is their a way to count records in a found set?

jay.

Edited September 30, 2010 by Guest
ID Field Type

[TheTominator]

In Browse mode, look at the indicator in the status area.

In a calculation you can evaluate Get(FoundCount)

[projay]

Hi and thanks for the quick reply. I created and field and applied the get(foundcount) function it shows me the count of all my records and not the found set. Do I need to add anything else to the function. Thanks jay.

[Søren Dyhr]

shows me the count of all my records and not the found set

You would best explain what's your take are on the two sets- I would say the majority here would say the get( function ... shows the found set?

--sd

[LaRetta]

Create a calculation and not a standard field. And make sure the calculation is set to 'do not store calculation...' in Storage Options.

[Quartekoen]

You might like to take a look at the FileMaker 8.5 Function Reference PDF. It will list all the functions that can be used in FileMaker, as well as explaining what they do and giving examples of how use them.

[projay]

Thanks again Laretta and everyone else that was right on, just checked the box in storage options and walla it worked. Thanks Jay.

[projay]

Thanks for the reference that will be help ful is their one for fmpro 9.

[Vaughan]

The FMP 9 docs have disappeared from the FMI web site. However download the FileMaker Pro 11 Functions Reference (in Support, Downloadable Resources, Documentation and Publications, Product Documentation, FileMaker Pro 11). Each function is marked with the version it was introduced in so you'll tell if it's in FMP 9 or not.

Update: you're lucky it's still on the server...

http://www.filemaker.com/downloads/pdf/fmp9_functions_ref.pdf

Edited September 29, 2010 by Guest