>>>>Kev,
>>>>Unfortunately that still does and OR not and AND across multiple records which is what I need.
>>>
>>>Oops, I'm not with it today.
>>>
>>>Do you have to achieve this in 1 select?
>>>
>>>Kev
>>
>>Ideally yes.
>
>I don't think it's going to be possible due to the nature of SQL, because you are asking for fields that have other values in different rows in a single statement.
>
>The easy way will probably be to write a function and embed it in a Select statment.
>
>If you do find a solution, let me know, I would be interested.
>
>Kev
Kev,
Check out message#830382 it appears to work but the select has to be constructed depending to the ItemID's required.