Thank you both for your help, it's much appreciated.

I see what I was doing wrong now, by not using the dpd table as the main 'from' table in the query.

Thanks both, it's much appreciated.