Totals row

chris89

Registered User.
Local time
Today, 15:45
Joined
Nov 28, 2011
Messages
71
(I know this might be a silly question...)
Is there a way on writing a custom function on the totals row in Access 2007?
I mean there is a dropdown with sum , max,min , etc .Can I write something my own?
 
You can write your own function but it will not show in the drop down nor will it aggregate your records ;)

The best place to do this sort of thing is in a report.
 
What do you mean by that?And how can I do it ?
Thank you a lot btw for your patience
 
You can write your own function but it will not show in the drop down nor will it aggregate your records ;)

I mean if you can do that what s the point if access can't do anything with it?
 
The functions you create will work on a per record basis but it just won't aggregate it for you. For example, if you wanted to create a Median function (because Access doesn't have this function), it won't display a unique set of records per group, but it will - if your coded it properly - display the results per record.
 
So if i understand this right I can't have a A,B,C field and at Totals row where sumA, sumB appears at column C were an expression like :(sumA-sumB/sumA)*100 .
is that correct?
 
Nope you can't. You should be doing that in a report as previously mentioned ;)
 

Users who are viewing this thread

Back
Top Bottom