IKEA opened its second Chicago-area store today in Bolingbrook (Chicago Tribune reg req'd), and some guy flew in and camped out front for the past 15 days to be the first person in. He did this knowing that the company has a history of rewarding the first customers at a new store, and sure enough, he got a $3000 gift certificate.

BTW, he didn't buy anything today.

I'm suprised that Access doesn't have an aggregate function for median. You'd think that would be really useful.

Wouldn't you? Since according to my Google search this question has been being asked at least since Access 97?

Guess I picked the wrong week to stop taking amphetamines.

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.