Subtotals on a Form

[branston]

Hi,

I think what I'm doing is quite simple (or at least it should be!), but its got me totally stumped!

I have a table with a load of numerical data in, against a month name & year. I have put this in a query which finds the totals for each month/year combo. I have now put this query in a form with the Total for everything at the bottom (in the form footer).

However.... what I want to do is to have a subtotal for each year, with thte total for it all at the bottom.

Basically, I want the same as you can do in reports with the Sorting & Grouping options, but I can't seem to find anything similar in Forms... surely there must be?!

Any ideas?!

Thank you

 

[gemma-the-husky]

not really - you can get a grand total of course

the thing is, a report is static - but a form isnt.
so a report actually consists of a series of detail and subtotal sections

a form doesnt look like this. there is just a single detail section.

also because a form isnt static, you can resort/filter etc the displayed items in a form. maybe its this that makes inbuilt subtotalling too hard.

I dont use them, but maybe a pivot table form (A2007) mght help.

--------------
you may be able to get somewhere near what you want, by having a subform to show the split totals, linked to the main form - but I still dont think you will see the detail and subtotals in each subsection.

 

[branston]

Oh. Thats a shame!
OK, I shall think of another way to show it - I eventually want a report showing the same thing, so at least I will be able to get it looking right for that!

Thanks for your help!

 

[branston]

ok... next problem (I know its a bit cheeky using the same post, but thought i'd save the explaination)
As I said above I needed to do it on a report - The totals in the grouped bits work fine, but my grand totals (in the page footer) are coming up with errors - any idea why?

 

[branston]

Ah, dont worry - works like a charm if I put it in the report footer - which is where i want it anyway, thinking about it!