I used to use MSAccess and I wish I could help but my MSAccess skills are rusty. Well, not so much rusty as the neurons have completely rusted out and fallen off my brain like an old tailpipe.

"A senior Sony executive has told a member of the Casino Royale production team that the new Bond will 'probably' be Pierce Brosnan," the website said.

For what value of "new", exactly?

God, people are stupid.

I figured out a way to make a report do it, but that makes it in the least useful format possible, and for some reason I can't even export it to Excel to make it at all more useful. Ffffuck.

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.