Replacing data in Table

[JackT]

I have replaced data in my table and now when I run a report I am missing information. Is there something I need to do after I replace data in a table to update all of my queries?

Thanks
Jack

[jzwp11]

When you say that you are "missing information", are you missing records or are you missing information from specific fields? Just replacing or changing data within records of a table will not cause you to lose data unless of course you removed that data. If you have queries that use constant values in the criteria and you removed those values in the corresponding fields, the query will no longer find that data which could result in fewer records returned.


If you altered the table structure itself (renamed fields, added fields, removed fields), then that will impact your queries.