Re: Null Query
From: Gary Walter (garylwpleasenospam_at_wamego.net)
Date: 05/18/04
- Next message: Curt Gough: "Re: Export to txt file"
- Previous message: Mark: "Re: Analyze with Excel"
- In reply to: Tony: "Null Query"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 18 May 2004 14:44:32 -0500
"Tony" <x34@hknet.com> wrote
> i have a query to sort out "is not null" record.
>
> However, i find there is null records in the result.
>
> Then i revert the query to "null", however, there is no record.
>
> apparently the visible "null" records are not null.
>
> then i check through the table, the record has nothing in the field. the
> field is a text field.
>
Hi Tony,
One method would be
WHERE
Len(Trim([SomeField] & "")) >0;
instead of
WHERE
[SomeField] IS NOT NULL;
Please respond back if I have misunderstood.
Good luck,
Gary Walter
- Next message: Curt Gough: "Re: Export to txt file"
- Previous message: Mark: "Re: Analyze with Excel"
- In reply to: Tony: "Null Query"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
