Yes, Jeff's solution does return all records, but what it does not do is give you data that is correct. Seeing how the Year is a varchar field and...

Actually the query works just fine on my 10,000 record table. The table won't be much bigger than it already is, so this solution works for me. I...

Sorry if I affended anybody, time constraints really stress people out. When stressed, some of the simpler problems tend to seem difficult. In case anybody is looking I...

Thanks, but i figured out my issue with a cartesian join. It appears you have too much time on your hands to post an article on the proper way...