Results 1 to 6 of 6
  1. #1
    drunkenneo is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jun 2013
    Posts
    199

    Search with in a recordset

    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.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Not really understanding the question. Do you want to apply filter to a report?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    drunkenneo is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jun 2013
    Posts
    199
    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?

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    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.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    drunkenneo is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jun 2013
    Posts
    199
    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.

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    I don't understand.

    Show example of raw data. Then show example of desired output.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 07-27-2014, 11:04 PM
  2. Replies: 6
    Last Post: 12-03-2013, 11:14 PM
  3. Replies: 2
    Last Post: 03-08-2012, 12:59 PM
  4. Recordset Search
    By ColPat in forum Programming
    Replies: 2
    Last Post: 08-14-2010, 08:25 PM
  5. Replies: 1
    Last Post: 11-13-2009, 03:03 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums