An alternative for locating null objects is: Select * from [table] where not obj
Quoting "B. Thoen" <[EMAIL PROTECTED]>: > On Tue, 2 Mar 2004, Chris Alexander wrote: > > What is the syntax to find a blank or null field in a table? Something > along > > the lines of 'is blank', 'is null', =" " (which doesn't return > anything)... > > If the field is a string, the test is ="" (no space between the quotes.) > If it is a number, the best you can do is see if it's zero. Same with a > logical. If you need to test an object, then use Str$(obj)="". > > - Bill Thoen > > > > --------------------------------------------------------------------- > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > Message number: 10677 > > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 10678
