Unmatched query - tough one

[Guest]

Database background:
I have a reconciliation database that essentially loads 2 stock files and
checks that the two reflect equal holdings.
The files are linked through a matching table that matches the stock codes
in one file and the stock name in the other file (unfortunately neither file
has both name and code).
The last query has the file 1 stock code next to the file 2 stock name and
does a calc of the difference in units held.
My question:
How do i create an unmatched query where the file 1 stock code does not
match off with its stock name counterpart (both are listed in the matching
table)?
I.e file 1 has no holdings for stock code ZCE, while file 2 has Zecne stock
name for 100 units?
Thanks
George

 

[Guest]

it would appear to me that there is insufficient commonality between the
tables to do an unmatch query. effectively all the records do not match.

if the record count between the tables is identical, and you can sort by
stock identically - then over in excel you could manually add the stock name
column to the table that only has the abbreviated symbol column.

or you could make a new table that has only two columns, stock name and
stock symbol......then create a MakeTable query that puts the full name into
the Table that has only the symbol.

in any case - while there is more than one way to skin the cat - I believe
you must make both tables have the full stock name (or have both tables have
the stock symbol) in order to proceed to the unmatched query phase of your
requirement.

possibly an MVPer has another technique to advise but that is the way I see
it at the moment....hope it helps a little