Thanks to everyone for trying this, it was bad data that was causing it not to work. I now have the problem corrected and everything working.

Thanks.
Ian

>Barbara (and Ian)
>I tried this with 2 queries linked with a JOIN and it seemed to work just fine.
>
>The OTHER BarbaraP.
>
>
>>Seems this ought to work, although I can't say that I've done a lot of commands that combine MIN and MAX. If you separate this into 2 separate queries, do you get the correct results?