when you have a query that returns multiple columns, and you use distinct, the distinct keyword returns a distinct rowset.
instead of using distinct, you need to use a GROUP BY clause
it looks like the title column would be a good candidate.
at the end of the sql add:
GROUP BY tbl_Resource.resource_title