I have a utility that will compare two tables, record by record, field by field, and spits out the differences into a text file. The output is not the easiest to read, expecially if there are memo fields with lots of text in them, but it definately works. Is that what you had in mind?

Update: Or you can create a quick report, send the output of each table to an ASCII file, then use something like BeyondCompare to see the difference in the text files, and export that to a nicely readable HTML file.


>Hi Vixens
>
>Is there a command or function or a ready-made that compares 2 records, say, same structure but in different sister tables? I want to quickly zip through two identical tables, checking if any of the fields are different. I've got a shed-load of tables to check so I don't want to be writing bespoke code to check evry field of each.
>
>Am I missing (or have i forgotten) something fundamental here?
>
>'ppreciate it
>
>Terry