Form Query Help 1

[xmeb]

Hi:

I am using the following query for a text box (DLookup) on a form which works fine. However, there are quite a few records where the "Residence Name" is null which means there is one null record at the top of the list that the query returns. Is there anyway to eliminate that null record from being returned?

Thanks,

xmeb

SELECT DISTINCT ResidencesTable.ResidenceName
FROM ResidencesTable;

 

[dhookom]

SELECT DISTINCT ResidencesTable.ResidenceName
FROM ResidencesTable
WHERE ResidenceName is not Null;

Duane
Hook'D on Access
MS Access MVP

 

[xmeb]

Duane:

That works perfect! It is exactly what I needed.

Thanks,

xmeb

 

[Andrzejek]

The way to show appreciation and to mark helpful posts, please use

[blue]
Like this post?
Star it![/blue]



Have fun.

---- Andy