B
B
Hey all. Got a small problem.
I have two make-table queries that go out to 2 different
SQL servers to extract data. On one of the queries, the
table that holds that data has many duplicate entries (
which is fine but not for what I need.)In that query, I
Group the dup's together so that I don't have them
repeating in the table that I create. The other one is
just a normal query. What I have a problem with is this.
If I create a mismatched query against the two tables,
the column with the dup's never appears in the list to
select in the mis-match query wizard. All the other
fields appear, but not that one. Show is checked. I
wonder if it has something to do with the fact that I'm
grouping the data.
I can't figure this out for the life of me.
Any ideas?
I have two make-table queries that go out to 2 different
SQL servers to extract data. On one of the queries, the
table that holds that data has many duplicate entries (
which is fine but not for what I need.)In that query, I
Group the dup's together so that I don't have them
repeating in the table that I create. The other one is
just a normal query. What I have a problem with is this.
If I create a mismatched query against the two tables,
the column with the dup's never appears in the list to
select in the mis-match query wizard. All the other
fields appear, but not that one. Show is checked. I
wonder if it has something to do with the fact that I'm
grouping the data.
I can't figure this out for the life of me.
Any ideas?