J
JT
I have query with 2 tables. When I run a query against
just Table 1, I get 708 items.
When I join Table 1 with Table 2 (product number) and run
the same query, I get 710 items.
The reason is two product numbers are duplicated in Table
2.
The problem is I do not have the ability to remove the
dupes from Table 2.
I'm looking for suggestions on removing the dupes from
Table 2 with either a query, make table query, macro,
etc....Thanks
just Table 1, I get 708 items.
When I join Table 1 with Table 2 (product number) and run
the same query, I get 710 items.
The reason is two product numbers are duplicated in Table
2.
The problem is I do not have the ability to remove the
dupes from Table 2.
I'm looking for suggestions on removing the dupes from
Table 2 with either a query, make table query, macro,
etc....Thanks