Hi Ray - you've made some valid points - unfortunately I was attempting to get this done for a deadline which was monday and was pretty confident I could work it out over the weekend.
I can get a bit stressed - sorry
I would like to understand the joining tables together but for now it would be helpful if you could paste an example of he query that would be similar to what I need to use - obviously I would need to adjust to the fields and tables I'm actually using.
is this possible?