ADDFIRM2

Returns specified field from the Firms table based on the Firm ID.

Reporting Area(s):

Course, Instructor, Names

Required Parameters:

1. Firm ID (i.e.nmfmid, infmid, cofmid)
2. Field from Firm Table to return (i.e. "fmcity", "fmextra", "fmcontact")

Optional Parameters:

None

Example(s):

ADDFIRM2(infmid,"fmcity") returns city of the instructor's firm

Notes:

Firm ID (nmfmid, infmid, cofmid) must be present in the cursor.

This function will converts all returned values to character format.

 

Related Topics