Copying my answers again? Do you ever have an original thought?

John... Visio MVP

"Steve" wrote in message
...
Hello John,

When a table has 225 fields, it is a certainty that your database tables
are misdesigned. This is a substantail problem that needs solved.

What constitutes a bad record? You can find the seven bad records with an
appropriate query.

Steve



"John Quinn" wrote in message
...
I have a table of 19,000 records with about 225 fields in each record. It
is
not an indexed table, just a table of educational transactions.

Some how when I go to update the historical table seven (7) records have
gotten some bad info in them. I know I can copy the table to another
database and look at them one field at a time, but this will take
forever.

Does anyone know a quick method of finding the seven bad records?

Thanks in Advance

John Q