is not null

[karenmierkalns]

I am trying to query an Access database through a VB interface.

I am getting this error:

Data provider or other service returned an E-FAIL status.

I am trying to get records that don't have a null field.

ie.

select * from table where field is not null

I also tried

select * from table where not isnull(field)

Either way I try this, I still get the above error message.

I am under the impression that the syntax is correct, but does not work with VB or with Access. Is there a way around this?

Thanks. - Karen

 

[karenmierkalns]

I think it may be my sql statement. I tried the same syntax on a two table join, and it worked fine.

Also, it may not be necessary, because I am redesigning my database so as to eliminate the need to even do the query with where not isnull(field).

Thanks anyway. - Karen