While I resolved one problem I had with not being able to split records correctly, I've stumbled upon another problem when creating a report for some back orders.

Here's an example of the data I have:

OrderNumber||Ship Date||Order Flags
QRT----------5/10/06----USHP
ABC----------5/15/06----USHP
ABC----------5/15/06----USHP
XYZ----------5/16/06----USHP
XYZ----------5/17/06----USHP

The reason the order numbers repeat is because the order number and the remaining information repeats on every line of that order and some lines ship on different days. So what I would like to do is filter out orders that have either just one Ship Date or have the same Ship Date. So above, QRT and ABC should be filtered out. I can filter out the single Ship Date easily (QRT), but is there a way to compare the first date from ABC to the second and eliminate that one?

I tried messing around with Distinctcount, however nothing's come of that yet.