Community
Showing results for 
Search instead for 
Do you mean 
Reply

How to search on Street Name?

New Member
Posts: 3
Country: United States

How to search on Street Name?

I want to be able to LOOKUP or search results for a particular Street Name in ADDRESS1 field,  how can I do this?
Moderator
Posts: 4,395
Country: USA

Re: How to search on Street Name?

You can either right click in the address field and select Lookup or go to the Lookup menu > Other Fields.
New Member
Posts: 3
Country: United States

Re: How to search on Street Name?

That does not work.. What I want is all addresses on ELM for example.  If the addresses are 101 ELM, 102 ELM, 103 ELM,  and I search for ELM, it returns no records.  Only if I put in the Street # does it return 101 ELM, but not the other ELM addresses.
Platinum Elite Contributor
Posts: 6,653
Country: USA

Re: How to search on Street Name?

For that you need to use the contains operator in an advanced query or %Elm% in a direct search from the field.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
New Member
Posts: 3
Country: United States

Re: How to search on Street Name?

Perfect!  Thanks Roy,  the % was what I needed, I tried to use " " but did not work.