Re: How to create a VBA function which can be used within a query

**CDMAPoster@fortunejames.com** · Jun 27 '08, 07:26 PM

On Jun 4, 11:49 am, Andrew <andrewmricha.. .@yahoo.co.ukwr ote:

Hi all
>
I am trying to create a function which can be used within the QBE grid
in Access.
>
The function is to calculate the median of a set of data.

Personally, for medians I skip the function entirely and just use SQL:

http://groups.google.com/group/comp.databases.ms-access/browse_frm/thread/b24f513ff5abf10a

James A. Fortune
CDMAPoster@Fort uneJames.com