is not null ??

L

Luke

Hi I'm trying to create a simple query.

I want to get all records that are not blank in "Purchases" , where
Purchases is a text field.

I tried putting Purchases in the query design view, I put purchases in
the row that says Field: and in the line that says citeria , I put !
notnull.

I get nothing. What am i doing wrong?

Thanks
 
D

Dirk Goldgar

Luke said:
Hi I'm trying to create a simple query.

I want to get all records that are not blank in "Purchases" , where
Purchases is a text field.

I tried putting Purchases in the query design view, I put purchases in
the row that says Field: and in the line that says citeria , I put !
notnull.

I get nothing. What am i doing wrong?
Click to expand...


In the criteria line, put:

Is Not Null

In fact, you can write "Not Null" in that line, and it will change it to "Is
Not Null".
 
Top