Conditional Select Distinct?
Posted on 1998-11-28
Is there such a thing as a conditional select distinct query? The records may have different names, dates, and PO's as well as a unique identifier. I want no duplicate addresses unless they have a different date. They can have a different name, PO, or ID but not the same date. I have tried a million different things and I can't figure it out. This is probably pretty easy but I haven't been at this very long. Any help would be greatly appreciated.