• Thanks for that I think I understand. However, the resulting data needs to populate a 3 column table:

    Col 1 - poit_supplier (Supplier Code - to be output only once for each supplier in the result)

    Col 2 - sum(poit_valord) (Sum of ALL Orders for a supplier placed locally)

    Col 3 - sum(poit_valord) (Sum of ALL Orders for a supplier placed non-locally)

    I hope this clarifies what I'm trying to achieve? Any ideas greatly appreciated

    Thanks

    Sean