The ACCESS Procedure for PC Files

SUBSET Statement

Adds or modifies selection criteria for a view descriptor.
Note: for DBF, DIF, WK1, WK3, WK4, Excel 4, Excel 5, and Excel 95 file formats under Windows operating environments view descriptor


SUBSET selection-criteria;


Use the SUBSET statement to specify selection criteria when you create a view descriptor. This statement is optional. If you omit it, the view retrieves all data (rows) in the PC file.
An editing statement, such as SUBSET, must follow the CREATE statement when you create a view descriptor.
See "CREATE Statement" for additional information.