>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


You can make cursor to be ordered any way you want ...
Issue SQL statement into writeable cursor

select ...  from ... where ...  into cursor myRptCursor readwrite
index on ... tag myrpttag

&&some preprocessing if necessary


report form myFrx ...

If FRX does not cut, have look at www.report-sculptor.com
With RS you can build report using ordinary form controls (form containers become bands)
and drive it any way you want. It can be totally dynamic if it need to be.
Tip: Use textbox.inputmask / Format properties for properly formating numbers.


See RS Demo Project for samples/ideas

HTH
Sergio