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