is not null ??

[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

 

[Dirk Goldgar]

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?

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".