"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.
And we live to fight another day.
Mal ,'Objects In Space'
Natter 39 and Holding
Off-topic discussion. Wanna talk about corsets, duct tape, or physics? This is the place. Detailed discussion of any current-season TV must be whitefonted.
Dana - Sep 28, 2005 11:42:14 am PDT #1676 of 10002
"I'm useless alone." // "We're all useless alone. It's a good thing you're not alone."
Emily - Sep 28, 2005 11:44:22 am PDT #1677 of 10002
"In the equation E = mc⬧, c⬧ is a pretty big honking number." - Scola
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.
Kathy A - Sep 28, 2005 11:44:39 am PDT #1678 of 10002
We're very stretchy. - Connie Neil
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.
Gudanov - Sep 28, 2005 11:47:10 am PDT #1679 of 10002
Coding and Sleeping
I'm suprised that Access doesn't have an aggregate function for median. You'd think that would be really useful.
Emily - Sep 28, 2005 11:48:10 am PDT #1680 of 10002
"In the equation E = mc⬧, c⬧ is a pretty big honking number." - Scola
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.
Gudanov - Sep 28, 2005 11:49:59 am PDT #1681 of 10002
Coding and Sleeping
Here's the Knowledge Base article on the Median, but you probably already have it: [link]
tommyrot - Sep 28, 2005 11:51:15 am PDT #1682 of 10002
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
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....
Aims - Sep 28, 2005 11:53:27 am PDT #1683 of 10002
Shit's all sorts of different now.
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.
Sean K - Sep 28, 2005 11:53:42 am PDT #1684 of 10002
You can't leave me to my own devices; my devices are Nap and Eat. -Zenkitty
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.
§ ita § - Sep 28, 2005 11:55:41 am PDT #1685 of 10002
Well not canonically, no, but this is transformative fiction.
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.