Filtering a recordset twice

Macdonald used Ask the Experts™
Hi guys,

Well i am generating reports using the data environment. My question is how do i filter my recordset twice.

my sample code is below but it is not giving correct results:


Set rs = Reports.rsrainfall_Grouping
rs.Filter str
rs.Filter str1


Reports is my data environment name
rs is a recordset variable which i have declared

Your help is greatly appreciated

Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Can you post the chunk of code u hav so that others or myself could have a better understading of ur question. thankx.
Why filter twice?  You can filter on multiple fields just like you can provide multiple fields in a where clause.  The second filter in your code is overwriting the first filter.  Use a single filter like " Name = 'MacDonald' and Address = '123 Anywhere'"

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial