UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Selecting a record that is not null or spaces    
 
   
rdemyan
post Sep 26 2005, 01:36 AM
Post #1

UtterAccess Guru
Posts: 976
How do I select a record(s) from a table that are not Null or spaces.

Maybe:

......Where Field1 Is Not Null Or Field1 <> ''

Thanks
Go to the top of the page
 
+
suntisuka
post Sep 26 2005, 03:24 AM
Post #2

UtterAccess Addict
Posts: 236
From: Bangkok, Thailand
If your field contain space (I mean one space, 2 spaces, ...), you can use

where NZ(trim(Field1),"") <> ""

But if your space mean Zero Length String, you can use shorter form

where NZ(Field1,"") <> ""

HTH
Go to the top of the page
 
+
rdemyan
post Sep 26 2005, 09:54 AM
Post #3

UtterAccess Guru
Posts: 976
Works fine. Thank you.
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 11:15 AM