Using Distinct when populating a Drop-Down Box

[MasterChief]

I have a Drop Down box that is being populated using the SQL Distinct
command. How do I get it so it doesn't show Null values?

Here is my SQL statement

sSQL = "SELECT DISTINCT Title FROM Everyone ORDER BY Title ASC"

 

[Dave Anderson]

I have a Drop Down box that is being populated using the SQL Distinct
command. How do I get it so it doesn't show Null values?

Here is my SQL statement

sSQL = "SELECT DISTINCT Title FROM Everyone ORDER BY Title ASC"

SELECT DISTINCT Title
FROM Everyone
WHERE Title IS NOT NULL
ORDER BY Title ASC



--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.

 

[Bob Barrows [MVP]]

I have a Drop Down box that is being populated using the SQL Distinct
command. How do I get it so it doesn't show Null values?

Here is my SQL statement

sSQL = "SELECT DISTINCT Title FROM Everyone ORDER BY Title ASC"

It depends. If you simply want to exclude Null values, then use a WHERE
clause:

sSQL = "SELECT DISTINCT Title FROM Everyone " & _
"WHERE Not Title IS NULL ORDER BY Title ASC"

If you want the Null value replaced by some text, then the answer depends on
the type and version of database you are using (please don't forget to
include that information when asking database-related questions - it is
almost always relevant)

Bob Barrows