Write an expression to omit blank rows in an Access 2000 query

J

Jense097

I am trying to write either an expression or criteria to omit rows if it
either doesn't contain data or along a few characters.
 
M

MGFoster

Jense097 said:
I am trying to write either an expression or criteria to omit rows if it
either doesn't contain data or along a few characters.
Click to expand...

Something like this:

SELECT ...
FROM ...
WHERE some_column IS NOT NULL
 
Top