Buffy: How was school today? Dawn: The usual. A big square building filled with boredom and despair. Buffy: Just how I remember it.

'The Killer In Me'


Buffistechnology 2: You Made Her So She Growls?  

Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!


Jon B. - Oct 06, 2006 10:28:52 am PDT #9138 of 10003
A turkey in every toilet -- only in America!

Bloglines vs. Google Reader

I had stuck with Bloglines because I didn't like Google Reader, but the upgrades may convince me to switch. Most importantly, Bloglines is blocked here at work, while I can still get at the Google. Winner: the Google!


tommyrot - Oct 06, 2006 10:32:16 am PDT #9139 of 10003
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.

Most importantly, Bloglines is blocked here at work

Why? Time-waster? Or do people use it to read naughty blogs?


Jon B. - Oct 06, 2006 10:35:37 am PDT #9140 of 10003
A turkey in every toilet -- only in America!

Probably timewaster. It seems like anything with "blog" in the name is blocked. Seriously. For example, I can get to wfmu.org, but not blog.wfmu.org.


Jon B. - Oct 06, 2006 11:10:07 am PDT #9141 of 10003
A turkey in every toilet -- only in America!

Microsoft Access 2003: I need an expression that takes the difference between two numbers, but returns 0 if the difference is negative. In Excel, I'd use max(num1-num2,0), but I can't find an equivilent in Access. Does it exist, or do I need to do an IIF statement?


tommyrot - Oct 06, 2006 11:11:36 am PDT #9142 of 10003
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.

what am I thinking....

or do I need to do an IIF statement?

Yes.

The lack of a Max() or Min() function in VBA is annoying. (Not to beconfused with Max and Min in SQL.)

eta: OK, here's a worse way of doing it: ((b-a) + Abs(b-a))/2


Jon B. - Oct 06, 2006 11:37:38 am PDT #9143 of 10003
A turkey in every toilet -- only in America!

OK, here's a worse way of doing it: ((b-a) + Abs(b-a))/2

Ha!

It is annoying though. All I needed was a way to make a number between 0 and 100% (i.e., no negative percents and nothing greater than 100%), and I had to use nested IIF statements. Ridiculous!


tommyrot - Oct 06, 2006 11:41:28 am PDT #9144 of 10003
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.

You could do:

IIF(b-a <0 Or b-a >100,0,b-a)

(Assuming the numbers have already been converted to %.)

eta: Oh wait, you pro'lly wanna convert >100 to 100, right? Then you gotta do the nested IIF.


Jon B. - Oct 06, 2006 11:45:15 am PDT #9145 of 10003
A turkey in every toilet -- only in America!

Forget the b-a part. That was just an example. I'm actually taking a complicated quotient. But besides that, I think your logic is flawed. Your statement returns 0 if b-a is greater than 100. It should return 100.

t edit Yes, your edit is correct!


tommyrot - Oct 06, 2006 12:05:04 pm PDT #9146 of 10003
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.

If you have to do this sort of calculation a lot, you could just write a function to handle it.


Jessica - Oct 06, 2006 4:08:31 pm PDT #9147 of 10003
If I want to become a cloud of bats, does each bat need a separate vaccination?

could someone post the link to the mobile version of google reader? the standard version keeps crashing my treo (java) and my flight's delayed an hour...