Recent content by TML15

Hi everyone! I've been asked to create a query using Design View (not SQL) to compare addresses in a table to addresses in another table that are listed in ranges and provide a list of addresses that match the ranges and a list that do not match the ranges. So, these are examples of the...

Brilliant! That works! Thanks again @arnelgp !!

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

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?

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!

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

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

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!

Thanks @MajP & @theDBguy for all of your invaluable help and to the others that also tried to assist! Your are amazing!

3. Make sure ID is in the form's query. - That's what it is. I substituted the sample data for the real data which does not have the ID column. Is the ID essential to the query?

One more question @MajP ... When opening the form, a pop up appears looking for a parameter I press OK and is goes away. I'm just wondering what is causing this prompt?

@MajP Perfect!! That's exactly what I was looking for!! I'm impressed how fast you create the code!

I've seen these examples and I like them. It doesn't work for ranges however. If the range starts at 1 and ends at 5, it won't find 2,3 or 4. I am intrigued by your Test_MajP zip file. You were able to have the street number filter within the range. This is what I'm trying to accomplish...

I don't mind it @MajP . I'm curious to know how it would do with a full 60000+ records where the drop downs could be quite long depending on how big the street is.

It is an interesting method that could work. My concerns are that it could be difficult when sorting through 60000+ records and also finding a street number within the address range. I'd like to test it out to see how easy or difficult it may be for the users.