I
Ian Elliott
Thanks in advance.
I have two tables that should be exactly alike, but might
be different since I changed the code in a form that makes
them.
I have tried doing a query to see if they are alike, by
opening a design query and choosing the two tables, then
copying all the fields from each table into the query (one
next to the other).
I then put in critera: <>[othertable].[otherfield]
Nothing shows up when I execute this, so it seems to be ok
(they must be exactly alike) (If I do a =[othertable].
[otherfield], all the records show.)
My question is: it's a lot of work copying in each field
from these tables, which have a lot of fields (20+) and
then copying into the criteria and changing field names.
Is there an easier way?
Thanks
I have two tables that should be exactly alike, but might
be different since I changed the code in a form that makes
them.
I have tried doing a query to see if they are alike, by
opening a design query and choosing the two tables, then
copying all the fields from each table into the query (one
next to the other).
I then put in critera: <>[othertable].[otherfield]
Nothing shows up when I execute this, so it seems to be ok
(they must be exactly alike) (If I do a =[othertable].
[otherfield], all the records show.)
My question is: it's a lot of work copying in each field
from these tables, which have a lot of fields (20+) and
then copying into the criteria and changing field names.
Is there an easier way?
Thanks