aggregate functions

[Guest]

I've written quite a few user-defined functions in vba in MS Access I was
just wondering: Is there any way to write a user-defined aggregate
function, like Access's Count, Min and Max functions that you use in your
queries?

[Allen Browne]

Re: aggregate functions

Yes, you can.

There is an example of a function that emulates DLookup() in this link:

http://members.iinet.net.au/~allenbrowne/ser-42.html

You should be able to use that as the basic idea to create your own count,
min, or max aggregation functions.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<arch> wrote in message news:414040e3$1 @funnel.arach.n et.au...[color=blue]
> I've written quite a few user-defined functions in vba in MS Access I was
> just wondering: Is there any way to write a user-defined aggregate
> function, like Access's Count, Min and Max functions that you use in your
> queries?[/color]