[AccessD] More data source issues

If SmplesizeAll is a checkbox, why not test for True instead of <> 0?
If you have your checkbox set up with no default value, which allows it
to be Null, which is not zero but also not true.

Charlotte Foust


-----Original Message-----
From: Joe Hecht [mailto:jmhla at earthlink.net] 
Sent: Wednesday, March 23, 2005 10:54 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] More data source issues


Thanks to Karen, I got the first problem handled.
 
SmplesizeAll = chkbox
SmpleSizePieces = txtbox
 
SmpleSizeAll is true in my test case, but the test keeps ending up at No
Sample Requested.
 
 
 
=IIf([SmpleSizeAll]<>0,"All
Pieces",IIf([SmpleSizePieces]<>0,[SmpleSizePieces],"No Sample
Requested"))
 
TIA
 
Joe
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com