The Filter property sets or returns a variant that contains a filter for the data in a Recordset object. The filter allows you to select records that fit a specific criteria.
Examples of a criteria string:
rs.Filter="Lastname='abs'"
rs.Filter="Lastname='abc' AND Birthdate >= #02/18/1986#"
rs.Filter="Lastname='jems' OR Lastname='Bond'"
rs.Filter= "Lastname LIKE bond*"
rs.Filter="[Company Name]='gemsworld' OR Cost >= 250"
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment