Assuming that you have retrieve the records from a database and now you want to filter the records further with more criteria. You can use the following code which filters the records using 2 criterias:
RS.Filter = "componentName = 'Monthly Salary' AND PayMonth = 1"
ComponentName is the 1st field name.Monthly Salary is the value to filter. It has to be presented between 2 singles quotes.
PayMonth is the 2nd field name 1 is the value to filter. Single quotes is not needed because it is a number.
To remove the filter, use
RS.Filter = adFilterNone
Share this page:
Would you prefer to share this page with others by linking to it?
Microsoft® and Microsoft Excel® are registered trademarks of Microsoft Corporation.
advanced-excel.com is in no way associated with Microsoft