Removing blank records from dynaset

[CAD Fiend]

Hello,

I am doing a select query for a lookup list (bound to a form) for street
names (to alleviate frequent misspellings by the users) and when I did
the initial select query, it came up with several blanks in the dynaset
(some of the records don't have a street name assigned yet). How do I
get the query to display ONLY the valid data (i.e. no blank records in
the dynaset)?

My table is called tblStreetNames and the field is called StName, if
that helps.

TIA.

Phil.

 

[Allen Browne]

In the Criteria row of the query, under the StName field, enter:
Is Not Null

 

[CAD Fiend]

Thank you, Allen.

In the Criteria row of the query, under the StName field, enter:
Is Not Null