Hi I developed a solution through MS Access where I have a query running over another query result to get the result consistently.  Now I wanted to do the same for Crystal report.

 

I thought about using existing report and add a sub report - establishing which table/field as the link to the main report.  However, I need guidance as I am not familiar with Crystal report, but you can imagine I have two MS Access query - the first one produce the first result.  The 2nd query is then based on the 1st one with additional tables added on.  This is what I want to achieve on Crystal report 8.5.

 

Please can someone help.  Thanks