Thanks for all your replies.

I have managed to get it working. The way to do it is:

I created a main report and then a sub report query. On the...

Yes you are right and originally I had the sumary report hyperlinking to a secondary report which was working fine. The requirements have now changed and they want it on...

Thanks for your responses, much appreciated.

What Im trying to achieve is have a summary report on the left and then depending on which "Project_Number" I click on it displays...

Thanks, Ill give it a go 🙂