>F1 F2 F3 F4 F5 >T 5 3 Y Cohen >G 7 2 Y Jones >G 4 3 Y Ming >R 0 1 Y Olson >Q 9 6 Y Roberts >R 2 4 Y Smith >------------------------------------------------------------------------------------------------------ >(Data Grouping when F4 changes) >Totals: >F1 F2 F3 # >G 11 5 2 records >Q 9 6 1 record >R 2 5 2 records >T 5 3 1 recordI suggest two tables - one with details and another with summay. Join them based on F4 field and use both of the tables in your report.