>I want to thank both of you for your replies.
> I'm hesitant to do Naomi's suggestion because it seems like I would need to run a SQL query every time that F4 changes.
> Borislav's idea seems good, but the cursor wouldn't be in the right order for the query. I should have used this as the example (notice that it's in order of F5):
>

>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 record

I 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.