Access Double Match

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?

Answer 1

Hi,

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

Answer 2

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 [e-mail].