I have a table of 19,000 records with about 225 fields in each record.
It sounds like you have a spreadsheet like Excel instead of a relational
database that is the intended purpose of Access.
If your data was 'normalized' then it might be easier to find something.

--
Build a little, test a little.


"John Quinn" wrote:

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