View Single Post
  #2  
Old March 8th, 2010, 06:06 PM posted to microsoft.public.access.tablesdbdesign
John... Visio MVP
external usenet poster
 
Posts: 900
Default Data Rules Violations

"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


It depends how you define bad. If you have a criteria, then you can write a
query to ientify those "bad" records.

John... Visio MVP