Form / Subform Query / Report

[Claire Jackson]

Hi,

I have a simple access form with a subform. I have created the query which brings all records up that I want but when I have created the report from the query,
it's putting all the data from the subform onto separate pages but I want it listed on the same page as the main form. I know it'll be a simple fix with grouping etc. but I'm stumped.

Any help would be appreciated.

 

[welshgasman]

See if this helps?

https://www.youtube.com/results?search_query=access+report+sort+and+group