B
brian
Can't seem to get this to work, need help please.
I'm trying to preform a mismatch query against two local
tables that I create from quering SQL DB's. Both queries
grad data and dump it into a temp tables in my Access db.
In one of the queries, the table it pulls the data from
has duplicates. I have the query properties setup so that
unique values = Yes so that it only pulls one instance.
This part works fine. When I try to do the mismatch query
against the two tables, the column that held the
duplicates ( which now doesn't locally ) never appears in
the wizard when it asks for data that appears in both
tables. I've tried without luck to get around this. I'm
positive that on both tables at least one column matches
one in the other.
Thanks for any assistance.
Its greatly appreciated.
I'm trying to preform a mismatch query against two local
tables that I create from quering SQL DB's. Both queries
grad data and dump it into a temp tables in my Access db.
In one of the queries, the table it pulls the data from
has duplicates. I have the query properties setup so that
unique values = Yes so that it only pulls one instance.
This part works fine. When I try to do the mismatch query
against the two tables, the column that held the
duplicates ( which now doesn't locally ) never appears in
the wizard when it asks for data that appears in both
tables. I've tried without luck to get around this. I'm
positive that on both tables at least one column matches
one in the other.
Thanks for any assistance.
Its greatly appreciated.