Microsoft KB Archive/107802
Searching for a Series of Matches in a Field for a Report
The information in this article applies to:
You can output different matches in the same field by either issuing a FOR clause or using the INLIST() function. For example:
REPORT FORM <file> FOR fname = "George" or fname = "Mike" -or- REPORT FORM <file> FOR INLIST(fname,"George","Mike")
Both commands will output all records with "George" or "Mike" in the FNAME field. NOTE: The INLIST() function can search for up to 24 sets of expressions. However, you may not be able to use 24 sets of expressions because of the 254-character limit on the command line.
Additional reference words: FoxDos FoxWin 2.00 2.50 2.50a 2.50b list choices KBCategory: kbprg KBSubcategory: FxprgGeneral
Last Reviewed: June 27, 1995