values in fields not responding...???

  • Thread starter Thread starter reagan123
  • Start date Start date
R

reagan123

okay i have a table with 12,000 records in it. i have a query tha
takes a fields value, '11-15 years', takes the 15 and adds it to th
current year.. it works for all of the records except for 106... i hav
checked the fields for hidden characters..(i.e.spaces/tabs/etc) an
there is nothing different about the fields than the ones that worked.
any suggestions for why these 106 are not updating...
thank
 
Not sure if this might help, but for what it is worth; I dont think tha
the "why" is as important as a possible fix. What I have done in th
past is,

1-MAKE A COPY OF YOUR DATABASE.

2-Work on the copy of your Database

3-Make a copy of the Table in the Database Copy

4-Delete the Records in question from the Original Table (in the Cop
of the Database)--making a list of the Record Numbers deleted

5-Copy and Paste one of the Records from the Copied Table to th
Original Table

6-Check and see if this copied record still has same glitch--if so
then enter the exact same info into a new record and see if you stil
get the glitch.

In my limited experience, tables with large numbers of records have ha
some weird anomalies that cant be understood--they can just be gotte
around or repaired. Hope this helps, "Ours is not to reaso
why......"

Good Luck

Lokima
 
Back
Top