Here's the Knowledge Base article on the Median, but you probably already have it: [link]

tommyrot, the problem is that I need the data divided by sex, department, degree, and title and then I need the median of the data for each group.

I asked my boss about this. The only non-code way he could think of would be to have a query where you sort and group by sex, department, degree, and title, then within those groupings you would do a count and divide that by two (let's say that = X), then do a subquery to find the Top X records of that grouping, sorted in descending order, and then use the First to find the particular record that would be the median. That makes my head hurt, but if I get a sec. I'll try to see if that would work.

I think code would be easier. How many records are you talking about, anyway?

You could also use Excel to attach to the Access table/query and then use the proper Excep functions to get the median. I don't know if this would get around the issue of the data being too big for Excel or not....

If I actually won that auction and got the phone call, I'd be so tongue tied, it's prolly go like this.

Celeb: Hi, Aimee! Congrats and thanks for the cash to the hurricane survivors.

Me: You're welcome. Oh, god. That wasn't funny or witty or anything. That was boring. I am charming! I swear I am. My daughter's pretty.

Celeb: .....

Me: Yeah. Bye.

I thought Bronsan took himself out of the running.

And yeah, that Cavill guy's face cries out for something rude to be done to it.

If I actually won that auction and got the phone call, I'd be so tongue tied

You should get tips from msbelle. I think a key one is to have the call take place at 3am.

I don't know if this would get around the issue of the data being too big for Excel or not....

The data's not too big. There are too many categories, so I'd have to find the end of each category and do the formula for each one and... honestly, it would probably already be done. But it did seem inefficient.

You should get tips from msbelle. I think a key one is to have the call take place at 3am.

If that were to happen, I'd forget and I'd have paid a bunch of money for Joe to tell Stephanie Romanov to go fuck herself. And not in the nice let him watch way, either.

I feel like I need to make another Red Cross donation now.

An NHL spokeswoman commented, "This ad is very respectful of women. The woman [dressing the player] is a spiritual and physical trainer for the warrior, and his mentor."

...riiiiiiiight.

And yeah, that Cavill guy's face cries out for something rude to be done to it.

For all values of "rude" that include "lewd", I'm right there with you. t goes to happy place

Hee!

Well, if it makes you both happy, then do it.