Thanks for the reply,
I have been messing about with it for a while using design view, with no luck, not that I fully understand what I'm doing anyway, my knowledge is fairly limited.
How do I modify the relation in that way? The join properties?
Also unsure how to use group by properly, :p...