Search with in a recordset

[drunkenneo]

I have list of Country's Data, i want to prepare reports for some selected countries and rest to the remaining to be put in common report.

I have made a recordset group of countries appearing, but how can i search if countries is from selected country from a recordset.

[June7]

Not really understanding the question. Do you want to apply filter to a report?

[drunkenneo]

I have a table with the following Data:

redemption_partner	country_name
Part SKU	Italy
Part SKU	Sweden
Part SKU	Israel
Part SKU	Poland
Part SKU	Lithuania
Part SKU	Israel

All other columns are not provided.

Here i want to generate all records having country name israel in Excel with output name as xxx_israel.xlsx.

And rest of the records in the output file xxx_sku.xlsx.

I have a recordset with redemption partner "Part SKU" and i want to search country exists then generate output otherwise give the common output i.e. xxx_sku.xlsx.

My problem is when the searching in the record set starts...for country name, Could you suggest other than filter?

[June7]

It's still not clear what you want but sounds like you want to do two exports to excel? What does 'redemption partner' recordset have to do with the example data posted? What is the relationship?

No, don't know anyway to do without applying filter.

[drunkenneo]

In simple means by the table i have made a recordset withthe prtner name first and then started taking out records countrywise from the recordset, but unable to achieve the common countries so far.

[June7]

I don't understand.

Show example of raw data. Then show example of desired output.