Web Development

Ask something
Question Locked

Access query

0 helpful
3 replies

by jiminpa

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need a little syntax help. I have an Access database and I want to query it the following way.

select col1,col2 from tblname where col2 not null

Is there a query like that? Can I do that?

3 replies

by cmiller5400

SELECT tblname.col1, tblname.col2 FROM tblname WHERE Not (IsNull(tbl.col2))

Edit: correct syntax

by jiminpa

As is often the case I can usually get close with my queries but my grammar oft times is not correct. I wish someone would write a database that accepted close enough

;)

This discussion is closed to new replies.