Semi-Complicated Median Query

[gcgoode]

Ooops, forgot that and I had already downloaded the file and reviewed. Will do some more.

First thing I did was test the function by calling from the VBA immediate window:

?DMedian("Age","Driver")

That returns 41.

So the function basically works.

Ok, thanks.



Yeah the only thing I've gotten to work is when I simplify the hell out of it I can usually get it to find the median of all TotalPremiums.

[June7]

Did lot more edits on that post. Review again.

[gcgoode]

Did lot more edits on that post. Review again.

Yeah, just saw it. The Polrate thing was smart. Ill keep trying to get this last query to work. Really starting to wonder if all that Im wanting to do is even possible in Access.

[gcgoode]

Did lot more edits on that post. Review again.

I know you're probably sick of looking at this, but I have one more quick question to ask you: Is it possible to add additional criteria to this median query? Right now the output is really close to what I want. It returns the fields Median, Age, Sex, and Marital status. But the Medians its calculating is only based on age. So in the output a 35 year old married female will have the same median as a 35 year old single male. I assume thats because in my code:

SELECT DMedian("PolRate","Query5","Age=" & [Age]) AS MedRate, Query5.Marital, Query5.Age, Query5.Sex
FROM Query5
GROUP BY Query5.Marital, Query5.Age, Query5.Sex;

The only criteria is age. I try to add more but my function Dmedian only calls for three arguments. And I haven't found a way to add more to that module without getting an error. Any ideas?

[June7]

DMedian("PolRate","Query5","Age=" & [Age] & " AND Sex='" & [Sex] & "'")

[gcgoode]

At long last, my query works. I can't thank you enough for all the help.