Stephen,
So I may be missing the point, but what is it exactly that your
complaining about? The fact that most MVP's don't know what their talking
about, that you don't know Access, or that the database is not properly
designed?
Jim.
-----Original Message-----
From: profoxtech-bounces At leafe .D.O.T com [mailto:profoxtech-bounces@leafe.com] On
Behalf Of Stephen Russell
Sent: Thursday, September 28, 2006 11:34 PM
To: profoxtech At leafe .D.O.T com
Subject: [NF] Access and the Null Blues
Ok, if you NZ() you can shove a value in for the null in access. Took 5
different MVPs before the sixth came in with that little trick.
I did it in the report via:
=IIf(Len(Trim([Trouser 1] & ""))>0,1,0)+IIf(Len(Trim([Trouser 2] &
""))>0,1,0)+IIf(Len(Trim([Trouser 3] & ""))>0,1,0)+IIf(Len(Trim([Trouser 4]
& ""))>0,1,0)
So you can see that I was forcing the freaking "" in there.
Repeat after me, access sucks.
Stephen Russell
DBA / .Net Developer
Memphis TN 38115
901.246-0159
http://spaces.msn.com/members/srussell/
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.407 / Virus Database: 268.12.9/458 - Release Date: 9/27/2006
[excessive quoting removed by server]
©2006 Jim Dettman |
