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.
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:
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.