John,
Thank you very much - it worked great.
Ozair
--- In MS_Access_Professionals@yahoogroups.com, <ms_access_professionals@yahoogroups.com> wrote:
Ozair-
The best bet is to break your search down into pieces that are likely to get a hit on what you want. Something like:
LIKE "Finch *" And LIKE "* 140*" And LIKE "*Ave*"
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of ozairkhalid@...
Sent: Saturday, September 21, 2013 8:13 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Search in Mailing Address
Hi,
I am looking for a QUERY that searches similar* mailing addresses.
*by similar, I mean search engine type results not EXACTLY matching.
If queried for "Finch Avenue 140, East"
it should bring similar addresses such as
"Finch Ave. 140 E" or "Finch Ave 140 East"
Ozair
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar