Sorry Naomi
Didn't ignore your messages on purpose any help always extremley appreciated as always.
Just thought on this occasion that Sergeys solution was easier to read, did mean to reply to you to but got caught up in it all.
Sorry again, many thanks for all your help, especially the link - Looks like I need to go there straight way! LOL
Best regards
Rob
>Hi Robin,
>
>Not sure why did you ignore all my messages.
>
>Anyway, I suggest you to start from
>
>
http://w3schools.com/sql/sql_join.asp>
>
>>Thanks again Sergey
>>
>>so I should have been going a JOIN ON, gotcha
>>
>>SQL is soooo powerful, I only need to touch the surface but can see what a useful laungage it is
Rob