Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
  • Table 1 Names
  • Table 2 Services

If I do a simple select of both tables together, I get a list as follows:

  • Name1 Service X
  • Name2 Service X
  • Name2 Service X
  • Name2 Service Y
  • Name3 Service Y
  • Name3 Service X

I would like to limit the list to only people who have Service X AND Y, one return per name (distinct select).

share|improve this question
    
Whoops, looks like my example table got squished. :( –  access_victim May 7 '13 at 15:44
    
Thanks for the edit! Giving them a pivot table of the data in excel. I find it a lot more comfortable and friendly than Access. Bleh. SSRS reports make more sense to build than Access. I'll still need to build something more automatic if they plan on seeing this updated with any frequency. Might just directly update Excel from the Access connection and not poke around inside anymore. –  access_victim May 7 '13 at 16:14
1  
Please include the actual queries you are using. –  terdon May 7 '13 at 16:28

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.