Question about Access selective function

  • Thread starter Thread starter Anna
  • Start date Start date
A

Anna

Hello,
I need help with Access.
What I am trying to do is basically having Access telling me which cells do
not repeat when 2 Excel files are combined in one query.

Sample:
File # 1 - Ana, Brian, Sam (in column cells)
File # 2 - Ana, Sam (in column cells)

So I need Access to give me result where it will show that Brian does not
exist in File # 2.

Probably is it something very easy. Just don't know how to do it.

Thanks in advance ,
Ana
 
Are you working in Excel or Access? The reason I ask is that your 'sample'
has 'files' and 'column cells' which Access does not.

Are you working with Excel worksheets that you have imported or linked into
Access?

Maybe what you need is an Unmatched query. That is a type you will find in
the wizard.
 
Back
Top