Access 2010 : Limiting records in a grouped report
Hello, My first time here. I hope someone will be able to help me.
I am trying to limit the number of records returned in a grouped report. I just want X number of records returned in each group.
I did find this thread in this forum as it applied to access-97.
I was successful with the first part of the instruction and I was able to add a control that numbers the records in each group. However I was unable to limit the output, it still returned all the records.
Should these instructions also work in 2010 or is there an extra step I need to do ? I can not figure it out. If anyone could help it would be appreciated