There's a rumor going around that Google is buying YouTube.

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!

Most importantly, Bloglines is blocked here at work

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

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.

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?

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

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!

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.

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!

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