Ahh, slight problem I found. I re-organised the tables and the joins and have cocked it all up. Using the original statement above, I needed RIGHT OUTER JOIN as the...

GilaMonster (5/21/2009)

---

Try using LEFT OUTER JOIN rather than INNER JOIN. Inner join only return rows where there is a match. Left outer join returns all the rows from the table...

Sorry, re-reading that I may not have been clear enough.

When you have a value in Room, Location and SubLocation in tblMedia the query runs without fault, however there is the...

Your problem looks almost the same as what is happening to me! -> LINK

I can't work it out, however it looks like it is down to permissions...

I've tried giving the Sql Service account rights on the remote folder (yep, we use a domain account) which failed. So I made a new share so it was at...

Ahhhhh right! That makes a whole load more sense.

I shall look into it.

Cheers!

That is perfect!!!

Thank you ever so much!

I do apologise. I'm unsure as to "DDL"...