Solved "None" in query

[TML15]

Sorry, newbie question:
I have a query that is attached to a drop down list in a form that includes the word "None".
Can I exclude "None" from the drop down menu? My ideas on how to solve this confuse "None" with Null or "0".

Thanks!

 

[theDBguy]

Hi. What is the Row Source for your dropdown? Can you add <>"None" to its criteria?

 

[TML15]

The Row Source is the query which has a criteria of Not is Null already

 

[theDBguy]

The Row Source is the query which has a criteria of Not is Null already

Okay, try adding <>None just below it.

 

[TML15]

Unfortunately, it didn't work. Is this how you suggested I try it?

 

[theDBguy]

Unfortunately, it didn't work. Is this how you suggested I try it?

View attachment 91346

Yes, exactly. What does "didn't work" mean? Did you get an error message?

Technically, the criteria should be: Is Not Null, instead of Not Is Null.

 

[TML15]

Yes, exactly. What does "didn't work" mean? Did you get an error message?

Technically, the criteria should be: Is Not Null, instead of Not Is Null.

Okay, I changed it to Is Not Null. Sorry, "didn't work" meant that the word "None" still appears in the drop down list.

Thanks!

 

[theDBguy]

Okay, I changed it to Is Not Null. Sorry, "didn't work" meant that the word "None" still appears in the drop down list.

Thanks!

Sounds like "None" may not be all it is. Just for fun, what do you get with using this in place of <>"None"?

Not Like "*none*"

 

[TML15]

Well, interesting idea...but same result. The word None is still there in the list. Could I possibly filter it out using the Properties of the Combo Box?

 

[theDBguy]

Could I possibly filter it out using the Properties of the Combo Box?

Of course, you can. But, it's very intriguing why any of the previous suggestions do not work. Are you able to share a copy of the db to show the problem? Maybe we can get to the bottom of it.

 

[TML15]

I attached a much condensed version. Please examine the NB_Search form

 

[isladogs]

Put both criteria on the same line in your query.
Is Not Null And <>"None"
NOTE I haven't looked at your database

 

[theDBguy]

Put both criteria on the same line in your query.
Is Not Null And <>"None"
NOTE I haven't looked at your database

Ah, that makes sense!

 

[arnelgp]

you can "replace" StreetTypeSym column of the query (both in qryStreetTypeNB and qryStreetTypeFilteredNB) to an expression:

Field: streetType: Nz([StreetTypeSym], "None")
Total: Group By
Criteria: <> "None"

 

[TML15]

you can "replace" StreetTypeSym column of the query (both in qryStreetTypeNB and qryStreetTypeFilteredNB) to an expression:

Field: streetType: Nz([StreetTypeSym], "None")
Total: Group By
Criteria: <> "None"

Brilliant! That works! Thanks again @arnelgp !!

 

[arnelgp]

goodluck