M
Magritte
I've decided to take the plunge and learn how to use Access 2007. I've set up
a database but am having difficulty with one task.
I have a master table with a unique integer ID and a text name which is
usually unique but technically may not be.
I have a separate list of names. I want to know which names in the second
list are or are not present in the master table, and for those that are
present, what are the unique IDs?
The second list of strings may match exactly the string in the master table,
or may match exactly but have a different case, or may be a subset of the
string inthe master table. I'd like to find all 3 cases. Where the match is a
substring, I'd like to find all strings in the master table that contain that
substring.
My first attempt was just to create a new table with a single field being a
text field, and each record holding one of the strings in the second list. I
then created a query containing the ID and name in the master table, and the
string in the second table, and creating a join between the string in the
second table and the string in the master table, with an arrow pointing
towards the master table.
And the result: no matches.
I then modified a few of the strings in the second table so that they
matcched exactly (including case) some record in the master table. But still
no matches.
So I'm at a loss as to how to get the result I'm looking for. Am I going
about this completely the wrong way or is there some little thing I'm not
doing?
Thanks for your help!
a database but am having difficulty with one task.
I have a master table with a unique integer ID and a text name which is
usually unique but technically may not be.
I have a separate list of names. I want to know which names in the second
list are or are not present in the master table, and for those that are
present, what are the unique IDs?
The second list of strings may match exactly the string in the master table,
or may match exactly but have a different case, or may be a subset of the
string inthe master table. I'd like to find all 3 cases. Where the match is a
substring, I'd like to find all strings in the master table that contain that
substring.
My first attempt was just to create a new table with a single field being a
text field, and each record holding one of the strings in the second list. I
then created a query containing the ID and name in the master table, and the
string in the second table, and creating a join between the string in the
second table and the string in the master table, with an arrow pointing
towards the master table.
And the result: no matches.
I then modified a few of the strings in the second table so that they
matcched exactly (including case) some record in the master table. But still
no matches.
So I'm at a loss as to how to get the result I'm looking for. Am I going
about this completely the wrong way or is there some little thing I'm not
doing?
Thanks for your help!