Ah thanks, I was originally trying to do something like that but it kept asking for the release field to be in the group by part of the query.

I assume...

Forgot to say the locations can only be between 1 and 8, though only 2 are shown here