...because God knows you need some satisfaction in life besides shagging Captain Cardboard! And I never really liked you anyway. And you have stupid hair!

Spike ,'Selfless'


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.


Emily - Sep 28, 2005 10:56:18 am PDT #1650 of 10002
"In the equation E = mc⬧, c⬧ is a pretty big honking number." - Scola

Oh. And now it seems to have decided that it's okay if I make something invisible, but I still have to leave room for it on the page or it refuses to do it, and just gives me 0 instead. Really. Out. Of. Patience.

Looks like I chose the wrong week to stop popping ludes.


Nutty - Sep 28, 2005 10:56:28 am PDT #1651 of 10002
"Mister Spock is on his fanny, sir. Reports heavy damage."

Fire? Like, office in flames fire? I've had bad days, but not days that bad.


Emily - Sep 28, 2005 10:57:17 am PDT #1652 of 10002
"In the equation E = mc⬧, c⬧ is a pretty big honking number." - Scola

The Supreme Court agreed to hear the case without awaiting the opinion of the new chief justice.

Maybe they just really don't like him.


sarameg - Sep 28, 2005 11:01:30 am PDT #1653 of 10002

If you have any other questions, don't hesitate to ask.

Is the new officemate going to resent me because my decorating scheme is "piles" while his appears to be nice pictures, organized bulletin board and white board and a bunch of those despair.com tchotchkes?


Fred Pete - Sep 28, 2005 11:02:29 am PDT #1654 of 10002
Ann, that's a ferret.

Smith's lawyer, Howard K. Stern

Howard Stern representing Anna Nicole Smith.

The mind boggles.


Tom Scola - Sep 28, 2005 11:03:17 am PDT #1655 of 10002
Mr. Scola’s wardrobe by Botany 500

If you have any other questions, don't hesitate to ask.

Does Wayne Brady have to choke a bitch?


tommyrot - Sep 28, 2005 11:03:58 am PDT #1656 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.

Emily, do you just need to find the median once? If so, create a new table that has all the fields of the existing table/query (or just the primary key), plus an additional autonumber field. Insert your records into the new table using a query that sorts your records by the field you want to find the median for. When you're done, note the larget autonumber value (on the last record), divide by 2 and find the resulting value autonumber field.

I've been wracking my brain trying to think of a bette non-code way of doing it, but haven't come up with anything.

eta: A much simpler way - just sort your table or query by the field you want the median. Note the number of records. Divide by 2, and type the resulting number in the record count box at the bottom left of query/table. Hit Enter.


bon bon - Sep 28, 2005 11:07:40 am PDT #1657 of 10002
It's five thousand for kissing, ten thousand for snuggling... End of list.

The Supreme Court agreed to hear the case without awaiting the opinion of the new chief justice.

That's because his opinion doesn't matter. False insinuations about the meaning of the cert-granting process are irritating.


§ ita § - Sep 28, 2005 11:07:44 am PDT #1658 of 10002
Well not canonically, no, but this is transformative fiction.

Fire? Like, office in flames fire? I've had bad days, but not days that bad.

Well, not the office. I drove past two on the way into work this morning (one brush fire, the other looked like a building fire). And emergency helicopters are now flying overhead on their way to a plume of white smoke further west.

It is not only fall (three rain showers in the past week), but fire season.


§ ita § - Sep 28, 2005 11:10:42 am PDT #1659 of 10002
Well not canonically, no, but this is transformative fiction.

Is the new officemate going to resent me because my decorating scheme is "piles" while his appears to be nice pictures, organized bulletin board and white board and a bunch of those despair.com tchotchkes?

No, they'll resent you for other reasons.

Does Wayne Brady have to choke a bitch?

God, yes.