Hey Sean thanks very much for that it does just what I wanted (Its hard sometimes not knowing where to start). Now going to read up some more and work...

Sorry Steve that's how I thought the Select Distinct worked ( im very new to this)

I didn't think about it not being able to tell if there were two entries...

Thanks for you answers, sorry for the messy code...

If I run the view and look at the returned data I can see the duplicates in the product_id field

39853

39853

are both the...

Hi Mark that worked just as I wanted.

Thanks very much for your speedy reply.:-)

John.