G
Guest
Hi: I have 2 tables in a db. Each one has the same 2 Field Items I am trying
to compare. Basically the entry table where the 2 Fields are entered need to
be compared against a master table to see if they exist. If they do not
exist I need the query to tell me that these 2 feilds in the entry table do
not exist in the master tbale. I can't seem to get a query to reflect those
results. The fields are text and the comparison has to be on both fields.
So if table 1 has ABC for field 1 and 123 for Field 2 it would have to find
the same match for Field 1 and 2 in the other table.
Table 1: (DMU_Entry-tbl) Field Name (HRA Model) Field Name (HRA Directory)
Table 2: (tbl_HRA_LOVs) Field (HRA Model) Field Name (HRA Directory)
Can this be done?
to compare. Basically the entry table where the 2 Fields are entered need to
be compared against a master table to see if they exist. If they do not
exist I need the query to tell me that these 2 feilds in the entry table do
not exist in the master tbale. I can't seem to get a query to reflect those
results. The fields are text and the comparison has to be on both fields.
So if table 1 has ABC for field 1 and 123 for Field 2 it would have to find
the same match for Field 1 and 2 in the other table.
Table 1: (DMU_Entry-tbl) Field Name (HRA Model) Field Name (HRA Directory)
Table 2: (tbl_HRA_LOVs) Field (HRA Model) Field Name (HRA Directory)
Can this be done?