I love to hate Access. I try to hate Access a little each day. Working in the basement server room in another building from my department means I don't get fired for hating Access out loud.
A lovely little bit of logic in my code that caught me was this:
There are some text-based records that will either have data, or no-data. I put in a conditional filter saying to include the records if they are <>"". I wasn't sure if they were blanks or nuls, but my thinking was that since this is an exception flag, it should just ignore it if the record is a nul.
Nope. It filtered out everything.
I changed it to filter on <>"Nul" and it spat out the records i was expecting.
W.T.F.
Maybe the logic centre in my brain is fried today, but by my thinking the first bit of logic should have spat out everything, whether it was a data-bearing record or a Nul since the condition would always be true. I... never mind. I'm going to head out and have some sushi and booze.
Erf, those look rare and expensive. Wouldn't a cheap old plastic Taco Hell spork do? ;-) Those stubby plastic "tines" it has makes it a surprisingly formidable scooping weapon. I'm sure it really could put out an eye.
I'm open to suggestions for alternatives, the restrictions being: 1) It has to be something 100% compatible with what I am using at work (MS Office 2003), 2) It has to be something that will run on Windows 2000 and 3) It has to be something that our IT department will support.
![[identity profile]](https://www.dreamwidth.org/img/silk/identity/openid.png){kind=small}
![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
branchandroot
no subject
Date: 2006-11-03 09:12 pm (UTC)Working in the basement server room in another building from my department means I don't get fired for hating Access out loud.
no subject
Date: 2006-11-03 09:58 pm (UTC)There are some text-based records that will either have data, or no-data. I put in a conditional filter saying to include the records if they are <>"". I wasn't sure if they were blanks or nuls, but my thinking was that since this is an exception flag, it should just ignore it if the record is a nul.
Nope. It filtered out everything.
I changed it to filter on <>"Nul" and it spat out the records i was expecting.
W.T.F.
Maybe the logic centre in my brain is fried today, but by my thinking the first bit of logic should have spat out everything, whether it was a data-bearing record or a Nul since the condition would always be true. I... never mind. I'm going to head out and have some sushi and booze.
no subject
Date: 2006-11-03 11:01 pm (UTC)no subject
Date: 2006-11-03 11:19 pm (UTC)no subject
Date: 2006-11-04 03:21 am (UTC)Wouldn't a cheap old plastic Taco Hell spork do? ;-)
Those stubby plastic "tines" it has makes it a surprisingly formidable scooping weapon. I'm sure it really could put out an eye.
no subject
Date: 2006-11-04 05:21 am (UTC)no subject
Date: 2006-11-06 03:11 pm (UTC)no subject
Date: 2006-11-06 03:46 pm (UTC)no subject
Date: 2006-11-06 03:49 pm (UTC)no subject
Date: 2006-11-07 04:07 am (UTC)no subject
Date: 2006-11-05 03:04 pm (UTC)