Only want the Sub-Report to be printed ( Access 2007)

[SWG]

I have created a Report & a Sub-Report for the same query, but i would like to see only the Sub-report summary (results) on the Report View. I have try to delete the main Report part of it but the Sub-Report result is not moving to the top of the Report View ( Sub-Report results appearing it below middle of the page).

Basically, I am trying to only print out the Summary (stats) , such as Average,Max, Min, Total,etc. from the Query that i created. I don't want to include any of the columns and rows.



I also try to make Report part to be Invisible, Which making the top part of the Report View to be blank space.


Please tell me if know how to solve this issue, Thanks for your time.

[June7]

If report and subreport use the same query as source why have subreport? Use report grouping & sorting with aggregate calcs instead of doing aggregate calcs in query. Aggregate calcs in group or report footer. Set the Detail section to not visible.