A
Adrian
Hi there,
I have 2 sets of data created into 2 seperated tables. They are linked
through a single PRIMARY KEY. Access's query is able to link and display
fields from these 2 tables if the PRIMARY KEY is correct. BUT what about
displaying all the fields where the PRIMARY FIELDS do not match?
example: -
Table 1
container number (primary key)
destination port
Table 2
container number (primary key)
destination port
I would like to show the the container numbers and destination ports from
both table 1 & 2 which DO NOT MATCH.
PLEASE HELP!! Thank you!
Regards,
Adrian
(a in-frequent access user)
I have 2 sets of data created into 2 seperated tables. They are linked
through a single PRIMARY KEY. Access's query is able to link and display
fields from these 2 tables if the PRIMARY KEY is correct. BUT what about
displaying all the fields where the PRIMARY FIELDS do not match?
example: -
Table 1
container number (primary key)
destination port
Table 2
container number (primary key)
destination port
I would like to show the the container numbers and destination ports from
both table 1 & 2 which DO NOT MATCH.
PLEASE HELP!! Thank you!
Regards,
Adrian
(a in-frequent access user)