Totals row

[chris89]

(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?

 

[vbaInet]

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.

 

[chris89]

What do you mean by that?And how can I do it ?
Thank you a lot btw for your patience

 

[vbaInet]

What do I mean by what exactly?

 

[chris89]

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?

 

[vbaInet]

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.

 

[chris89]

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?

 

[vbaInet]

Nope you can't. You should be doing that in a report as previously mentioned

 

[chris89]

Ok thank you a lot

 

[vbaInet]

No problemo!