Hi all,
In Access 2007, you can now create a form, display it in datasheet view, and specify that the sheet display Totals (Home ribbon, records group). Once turned on, you can select count, sum, average, etc for each column at the bottom of the datasheet. This is a really cool feature, right?
But does anyone know if there is a way to reference items in this totals row so that the values calculated there might be used for other purposes? I know I can create unbound objects, use aggregate functions as control sources, and get the information that way, but it seems redundant when Access is already doing it for us.
I can't find anything about this in any of my manuals, nor in MSDN or the MS Knowledgebase--I can't even find the totals feature documented! Maybe that's because I don't know the "official" name of this feature?
Thanks,
In Access 2007, you can now create a form, display it in datasheet view, and specify that the sheet display Totals (Home ribbon, records group). Once turned on, you can select count, sum, average, etc for each column at the bottom of the datasheet. This is a really cool feature, right?
But does anyone know if there is a way to reference items in this totals row so that the values calculated there might be used for other purposes? I know I can create unbound objects, use aggregate functions as control sources, and get the information that way, but it seems redundant when Access is already doing it for us.
I can't find anything about this in any of my manuals, nor in MSDN or the MS Knowledgebase--I can't even find the totals feature documented! Maybe that's because I don't know the "official" name of this feature?
Thanks,
