MATCHREF

Returns number of records in any table that match the specified condition based on a field in the cursor.

Reporting Area(s)

General

Required Parameters

1. Character search value: table to search in quotes (i.e. "NAMES")
2. Match value: field from cursor to match without quotes (i.e. fmid)
3. Match value: field from table to match in quotes (i.e. "nmfmid")

Optional Parameters

4. Condition to return count (i.e."nmcity='Manhattan' ")

Example(s)

MATCHREF("NAMES",fmid,"nmfmid") returns number of people in Names table with particular firm

MATCHREF("NAMES",fmid,"nmfmid","nmcity='Manhattan' ") returns number of people in Names table from Manhattan (city) with particular firm

Related Functions

COUNTIT
COUNTNAME
COUNTREG
GETSQLCOUNT
HOWMANY