>>Marc,
>>
>>I'm assuming that the output for this is a report, perhaps that's where I miss the boat. However, if we're out to sea, rather than "up the creek", then this will still work in the form of a summary report. Just group by HAWB, and sum in the report. Admittedly, this may not be the best solution, but, hey, if it works...well, at least we've got a paddle.
>
>Right. But I brought this up because this seems a not so unusual query and that you cannot do this in SQL. That's strange no, 20 years after DATE and Codd.
>
>>
>>Still no CD here at the office.
>
>OK. I believe you.
>
>Actually, I got that quote out of an ancient document, my high school year book. I added the bit about C/S students, because it seemed to apply. I had a professor that took two weeks simply defining things in my first class in second year C/S.
>>
>Too much is too much.
>
>Marc

Marc,

It seems like I've done this, but I can be sure without data sets that more closely match your's. I'm going to generate them tomorrow and see if there isn't a way to do this. Maybe in the meantime, someone else can solve this. You're absolutely right, it would seem that it "should" be easy. If I come up with a brillant (lotsa luck!) solution, I'll post it tomorrow.

...but it's always best to have more than enough.

George