VA FileMan V. 22.0 Getting Started HTML Manual Banner

 

Contents: Main Chapter See Also: Getting Started Manual Programmer Manual

VA FileMan Functions

COUNT

Format:
  1. COUNT(fname)

  2. COUNT(fname:field)
Parameters:
  1. In the first format, fname is the name of a file or of a Multiple in your current file.
  2. In the second format:

    • fname is the name of your current file or Multiple.

    • field is the name of a field (or a field number preceded by #) in fname.
Use: This function counts the number of entries in a file or in a Multiple. You can count the lines in a word processing field by using the first format with the word processing field name as the fname. If the second format is used, the number of entries with non-null values in field is returned.
Examples:
  1. COUNT(PATIENT) -> 1349 [the number of entries in the PATIENT file]

  2. COUNT(PATIENT:PROVIDER)=> 1288 [number of patients with providers recorded]

 

Reviewed/Updated: March 4, 2007