Microsoft KB Archive/107802

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 14:02, 20 July 2020 by X010 (talk | contribs) (Text replacement - "<" to "<")

Searching for a Series of Matches in a Field for a Report

ID: Q107802

The information in this article applies to:

  • Microsoft FoxPro for Windows, versions 2.5, 2.5a, and 2.5b
  • Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, 2.5a, and 2.5b

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"


   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
© 1999 Microsoft Corporation. All rights reserved. Terms of Use.