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.
Inara: We thought we lost you. Mal: Well, I've been right here.
'Out Of Gas'
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:35:37 am PDT #9140 of 10003
A turkey in every toilet -- only in America!
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...
dcp - Oct 06, 2006 4:15:55 pm PDT #9148 of 10003
The more I learn, the more I realize how little I know.
Jessica - Oct 06, 2006 4:18:50 pm PDT #9149 of 10003
If I want to become a cloud of bats, does each bat need a separate vaccination?
oh you are made of awesome!