D
d
Hi, all
I am trying to figure out an effective routine to comparing a number of
fields (around 20) between two tables (The two tables are identical) the
results would be the record source for a form.
The query below is a example of a routine I have been working with.Names of
tables etc have been cut down
SELECT T1.ID, “HD" AS [CF], T2.[HD] AS [CF]
FROM T1 INNER JOIN T2 ON T1.ID = T2.ID
WHERE (((T1.[HD])<>[T2].[HD]))
I have been thinking along the lines of making “HD" and [HD] into string
variables and then looping with a new field name etc until end of records.
Any help in achieving this or alternative approaches would be most
appreciated
I am trying to figure out an effective routine to comparing a number of
fields (around 20) between two tables (The two tables are identical) the
results would be the record source for a form.
The query below is a example of a routine I have been working with.Names of
tables etc have been cut down
SELECT T1.ID, “HD" AS [CF], T2.[HD] AS [CF]
FROM T1 INNER JOIN T2 ON T1.ID = T2.ID
WHERE (((T1.[HD])<>[T2].[HD]))
I have been thinking along the lines of making “HD" and [HD] into string
variables and then looping with a new field name etc until end of records.
Any help in achieving this or alternative approaches would be most
appreciated