Select Records by Most Recent Date

[Grimjack]

You are trying this in the same db copy that you posted, or in your original db? If in the original, that is not what I have to play with. That might explain why.

I made so many alterations on the db, based on the suggestions here...I cannot recall which one I posted here. I will add the version I am using now.

Willow WCF.zip

[Micron]

Those two files have different tables, at least by name. I was going to ask if you tried post 7 but I guess that's based on the wrong tables also.

[Grimjack]

Oh man...why is it that sometimes the answer (not always the 'right' answer) is right in front of your face? Looking at my results I realized I needed to remove the records which had data in the Code field. I simply added 'Is Null' to that field and got the results I wanted. Thanks to everyone who helped.

- Grimjack