none
Access Double Match RRS feed

  • Question

  • I'm wanting to know if Access can match two separate spreadsheets back to back, for instance:

    I currently match one column to access from two separate spreadsheets, but I am trying to filter first then match by a certain field. Is there a way to do this?

    Thursday, July 20, 2017 3:15 PM

All replies

  • Hi,

    I want to say yes, but I'm not sure I understand what you're trying to do. Can you please elaborate? Thanks.

    Thursday, July 20, 2017 3:18 PM
  • Hello ChelleWilliams,

    You could share some sample data and screenshots about your expected result to clarify the scenario. If your account is not verified, you could follow Share OneDrive files and folders to upload the screenshots into OneDrive and share the link here.

    Regards,

    Celeste


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, July 21, 2017 8:08 AM
    Moderator