SubTotal on a Form

[babs]

I've this unique situation.

e.g. my table has two fields key,Name, Marks
I've the records for Key 1 to 10

In my form, I want to display records 1 to 5, show a subtotal and then show another 6 to 10, show a subtotal and finally GrandTotal.

In continous forms, I cannot enter a control inbetween the records but at the end in the footer to show Grand Total.

Any help please ?

 

[Carol]

The best and easiest way to achieve this is to have a main form with 2 subforms in continuous view. Each subform, would have its query set to only select records 1 through 5 for the 1st subform, and then records 6 through 10 for the 2nd subform. Within each subforms footer, create an unbound textbox to sum the totals, and then reference this textbox within the main form. From there it is easy to create an additional unbound textbox that will sum to result for a total.