Simple Syntax Q for You

[Amanda V]

Hi All,

I'm using Access and VB to make a program:

I was wondering how to make an SQL query that filters a recordset for
column A given that the corresponding Column B contains a "nothing"
(null, empty... whatever).

That is, If the user has not entered a value into Column B (which is
of type Text), I want to say

SELECT ColumnA FROM tbl WHEN TestCondition = "Nothing" .

I guess I just don't know how to word the syntax is the problem.

Thanks for your time,

A

 

[Ken Snell \(MVP\)]

SELECT ColumnA FROM tbl
WHERE ColumnB Is Null;

 

[tina]

SELECT FieldNameA FROM TableName WHERE FieldNameB Is Null;

hth