D
don
Hi Group,
Newbie trying to learn some basics. I have a list of addresses and
have created queries to return postcode matches. Each query returns
perhaps 20 different addresses. To cut this list down I've created a
query using a table which provides the property number and the
postcode. That works fine. Where I get stumped is where the property
has a name not a number or perhaps both.
I am trying, so far without success, to compile a query that looks for
postcode and either property number or name, which would include an
added safeguard that would return alternate property matches in case
of a misspelling, ie Brimond instead of Brimmond. On this I've tried
using a match using Left, 1 but don't know/understand enough of the
access syntax.
Any help would be greatly appreciated.
Regards
DonH
Newbie trying to learn some basics. I have a list of addresses and
have created queries to return postcode matches. Each query returns
perhaps 20 different addresses. To cut this list down I've created a
query using a table which provides the property number and the
postcode. That works fine. Where I get stumped is where the property
has a name not a number or perhaps both.
I am trying, so far without success, to compile a query that looks for
postcode and either property number or name, which would include an
added safeguard that would return alternate property matches in case
of a misspelling, ie Brimond instead of Brimmond. On this I've tried
using a match using Left, 1 but don't know/understand enough of the
access syntax.
Any help would be greatly appreciated.
Regards
DonH