Filtering and Ordering Recordsets

Whenever you work on records in a database, it is rare that you want to carry out an action on the entire table, although if you did, you would be best served by using an action query, because queries operate much faster on large numbers of rows than do row processing methods (recordsets). However, it is more likely that you'll want to do something with a subset of records, and that means you would need to filter your query to select only those records that you wanted to work on.

With recordsets, you have the additional opportunity to sort the records, so you can operate on them in a specific order, perhaps by ascending date, for example. This section is concerned with illustrating how to filter your recordsets and order their output.

0 0

Post a comment