Thanks, I've actually worked out we don't need to select the RefTypeWord, so removing this from the select and making dbPatID distinct bought back the correct amount of rows.

I compared this with your sql and it brings the same result set back which is good.

thanks for your help.