Sorry about my first post being like this,but its sort of urgent. Having looked all over the internet this afternoon, I am quite tired and frustrated. And I need this for office tomm morning.
So i have a table with multiple columns. I think its better i explain by an example.
Eg:
C1 C2
1 X
1 X
2 X
2 Y
3 Y
4 Y
4 Y
5 X
5 X
5 X
.....
30,000
I need to filter C1 so that it will have both X & Y.(C2 is always X or Y). So in this case I need to get only 2 as it has both X & Y. So it shoudl appear like this:
C1 C2
2 X
2 Y
Then I need to export this to excel.
I tried to run the query WHERE C2="X" or C2="Y". But it hangs up,maybe bcos there are 4 more columns and I have filtered them, just can't filter this part.
Oh my knowledge level of access is average to slightly above avg.
Thank you very much for your help.
So i have a table with multiple columns. I think its better i explain by an example.
Eg:
C1 C2
1 X
1 X
2 X
2 Y
3 Y
4 Y
4 Y
5 X
5 X
5 X
.....
30,000
I need to filter C1 so that it will have both X & Y.(C2 is always X or Y). So in this case I need to get only 2 as it has both X & Y. So it shoudl appear like this:
C1 C2
2 X
2 Y
Then I need to export this to excel.
I tried to run the query WHERE C2="X" or C2="Y". But it hangs up,maybe bcos there are 4 more columns and I have filtered them, just can't filter this part.
Oh my knowledge level of access is average to slightly above avg.
Thank you very much for your help.
