Overclock.net banner

1 - 7 of 7 Posts

·
AKA StubbornGreek
Joined
·
3,813 Posts
Discussion Starter #1
I've created a Query that populates several fields of a particular table. Now, I want it to filter the results and return only those rows with one particular field populated.

In other words, say the 5th field of the Query is blank, I would want it to exclude this record, and every other record that has a blank 5th field.

Thanks.
 

·
Premium Member
Joined
·
65,162 Posts
Provide an example of that data?

Subquery with a where clause using IsNull?
 

·
Premium Member
Joined
·
65,162 Posts
Quote:


Originally Posted by RonindeBeatrice
View Post

"select field,field2,field3,field4,field5 from table where field5 <> '' "

you might have to use ... "where (field5 <> '' and field5 is not null)"


A catch all: "where len(trim(field5)) > 0"
 

·
AKA StubbornGreek
Joined
·
3,813 Posts
Discussion Starter #7
Quote:

Originally Posted by RonindeBeatrice View Post
"select field,field2,field3,field4,field5 from table where field5 <> '' "

you might have to use ... "where (field5 <> '' and field5 is not null)"

Quote:

Originally Posted by DuckieHo View Post
A catch all: "where len(trim(field5)) > 0"
Excellent, thank you.

Now, one more question (sorry sort of noobish with access '07). If I remember correctly, there should be an Administer or Administrator button on the Database Tools portion of the Ribbon, no (its not there now)? If not, how does one set permissions for different users (i.e. User 1 gets forms xyz and zyx while User 2 gets forms abc and cba)?

EDIT: Never mind, I just remembered that was for '03 formats - I figured out the rest. Thanks again,
 
1 - 7 of 7 Posts
Top