find unmatched in one table

[automaticbaby]

I have a table with month/year headers in sequencial order and a header that lists only the months of the year. Each month/year field that has a value only has value of X. I would like to create a query that looks at two months and returns only the month/year column where one month has an X and the other does not, ignoring blanks and where both have an X. Can this be done and if so, how?

Thanks

 

[RickSpr]

Your post is so jumbled and ambiguous that I don't know where to begin asking for clarification. Read the FAQ in my signature line and start a new thread. (In fact, if you think through it clearly enough to explain it properly, you may find the answer on your own.)

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein